Trigger.Update Property

  • Article

 

Applies To: SQL Server 2016 Preview

Gets or sets the Boolean property value that specifies whether the trigger is fired when records are updated in the table.

Namespace:   Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

Syntax

[SfcPropertyAttribute(SfcPropertyFlags.None | SfcPropertyFlags.Standalone | SfcPropertyFlags.SqlAzureDatabase | SfcPropertyFlags.Design | SfcPropertyFlags.Matrix)]
public bool Update { get; set; }

public:
[SfcPropertyAttribute(SfcPropertyFlags::None | SfcPropertyFlags::Standalone | SfcPropertyFlags::SqlAzureDatabase | SfcPropertyFlags::Design | SfcPropertyFlags::Matrix)]
property bool Update {
    bool get();
    void set(bool value);
}

[<SfcPropertyAttribute(SfcPropertyFlags.None | SfcPropertyFlags.Standalone | SfcPropertyFlags.SqlAzureDatabase | SfcPropertyFlags.Design | SfcPropertyFlags.Matrix)>]
member Update : bool with get, set

<SfcPropertyAttribute(SfcPropertyFlags.None Or SfcPropertyFlags.Standalone Or SfcPropertyFlags.SqlAzureDatabase Or SfcPropertyFlags.Design Or SfcPropertyFlags.Matrix)>
Public Property Update As Boolean

Property Value

Type: System.Boolean

A Boolean value that specifies whether the trigger is executed when records are updated .

If True, the trigger is executed when records are updated.

If False (delete), the trigger is not executed when records are updated.

Examples

Legacy Code Example

Creating, Altering, and Removing Triggers

See Also

Trigger Class
Microsoft.SqlServer.Management.Smo Namespace

CREATE TRIGGER (Transact-SQL)
Unable to find linked topic 'fface999-424a-4815-bc04-cbbd168c65ab'.

Return to top