• Article

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.ReadOnlyAfterCreation)> _
Public Property UpdateAction As ForeignKeyAction
    Get
    Set
'Usage
Dim instance As ForeignKey
Dim value As ForeignKeyAction

value = instance.UpdateAction

instance.UpdateAction = value

[SfcPropertyAttribute(SfcPropertyFlags.ReadOnlyAfterCreation)]
public ForeignKeyAction UpdateAction { get; set; }

[SfcPropertyAttribute(SfcPropertyFlags::ReadOnlyAfterCreation)]
public:
property ForeignKeyAction UpdateAction {
    ForeignKeyAction get ();
    void set (ForeignKeyAction value);
}

[<SfcPropertyAttribute(SfcPropertyFlags.ReadOnlyAfterCreation)>]
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.