共用方式為


ForeignKey.DeleteAction 屬性

Gets or sets the action taken when the row that is referenced by the foreign key is deleted.

命名空間:  Microsoft.SqlServer.Management.Smo
組件:  Microsoft.SqlServer.Smo (在 Microsoft.SqlServer.Smo.dll 中)

語法

'宣告
<SfcPropertyAttribute(SfcPropertyFlags.None Or SfcPropertyFlags.ReadOnlyAfterCreation Or SfcPropertyFlags.Standalone Or SfcPropertyFlags.SqlAzureDatabase Or SfcPropertyFlags.Design)> _
Public Property DeleteAction As ForeignKeyAction 
    Get 
    Set
'用途
Dim instance As ForeignKey 
Dim value As ForeignKeyAction 

value = instance.DeleteAction

instance.DeleteAction = value
[SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.ReadOnlyAfterCreation|SfcPropertyFlags.Standalone|SfcPropertyFlags.SqlAzureDatabase|SfcPropertyFlags.Design)]
public ForeignKeyAction DeleteAction { get; set; }
[SfcPropertyAttribute(SfcPropertyFlags::None|SfcPropertyFlags::ReadOnlyAfterCreation|SfcPropertyFlags::Standalone|SfcPropertyFlags::SqlAzureDatabase|SfcPropertyFlags::Design)]
public:
property ForeignKeyAction DeleteAction {
    ForeignKeyAction get ();
    void set (ForeignKeyAction value);
}
[<SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.ReadOnlyAfterCreation|SfcPropertyFlags.Standalone|SfcPropertyFlags.SqlAzureDatabase|SfcPropertyFlags.Design)>]
member DeleteAction : ForeignKeyAction with get, set
function get DeleteAction () : ForeignKeyAction 
function set DeleteAction (value : ForeignKeyAction)

屬性值

型別:Microsoft.SqlServer.Management.Smo.ForeignKeyAction
A ForeignKeyAction value that specifies the action taken when the row that is referenced by the foreign key is deleted.

備註

The DeleteAction property can be used to specify that the action is cascaded. This means that the foreign key row is also deleted. You can also set the foreign key to the default value, or set it to Null.

範例

建立、改變和移除外部索引鍵

請參閱

參考

ForeignKey 類別

Microsoft.SqlServer.Management.Smo 命名空間

其他資源

建立與修改 FOREIGN KEY 條件約束

CREATE TABLE (Transact-SQL)