Свойство 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.
Примеры
Создание, изменение и удаление внешних ключей
См. также
Справочник
Пространство имен Microsoft.SqlServer.Management.Smo