ForeignKey.UpdateAction Property
Gets or sets the Boolean property value that specifies whether the foreign key supports cascading updates.
Namespace: Microsoft.SqlServer.Management.Smo
Assembly: Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)
Syntax
'Declaration
<SfcPropertyAttribute(SfcPropertyFlags.None Or SfcPropertyFlags.ReadOnlyAfterCreation Or SfcPropertyFlags.Standalone Or SfcPropertyFlags.SqlAzureDatabase Or SfcPropertyFlags.Design)> _
Public Property UpdateAction As ForeignKeyAction
Get
Set
'Usage
Dim instance As ForeignKey
Dim value As ForeignKeyAction
value = instance.UpdateAction
instance.UpdateAction = value
[SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.ReadOnlyAfterCreation|SfcPropertyFlags.Standalone|SfcPropertyFlags.SqlAzureDatabase|SfcPropertyFlags.Design)]
public ForeignKeyAction UpdateAction { get; set; }
[SfcPropertyAttribute(SfcPropertyFlags::None|SfcPropertyFlags::ReadOnlyAfterCreation|SfcPropertyFlags::Standalone|SfcPropertyFlags::SqlAzureDatabase|SfcPropertyFlags::Design)]
public:
property ForeignKeyAction UpdateAction {
ForeignKeyAction get ();
void set (ForeignKeyAction value);
}
[<SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.ReadOnlyAfterCreation|SfcPropertyFlags.Standalone|SfcPropertyFlags.SqlAzureDatabase|SfcPropertyFlags.Design)>]
member UpdateAction : ForeignKeyAction with get, set
function get UpdateAction () : ForeignKeyAction
function set UpdateAction (value : ForeignKeyAction)
Property Value
Type: Microsoft.SqlServer.Management.Smo.ForeignKeyAction
A Boolean value that specifies whether the foreign key supports cascading updates.If True, all rows containing the foreign key are also updated when you attempt to update a row with a key that is referenced by the foreign key.If False (default), the foreign key is not updated.