ScriptingOptions.Triggers ScriptingOptions.Triggers ScriptingOptions.Triggers Property

Definition

Gets or sets the Boolean property value that specifies whether to include the definition for triggers in the generated script.

public:
 property bool Triggers { bool get(); void set(bool value); };
public bool Triggers { get; set; }
Public Property Triggers As Boolean
Property Value

A Boolean value that specifies whether to include the definition of triggers in the generated script.

If True, the trigger definitions are included in the script. Otherwise, False (default).

Examples

The following code example specifies that trigger definitions will be scripted

Visual Basic

Dim scOps As New ScriptingOptions()  
scOps.Triggers = true  

PowerShell

$scOps = New-Object Microsoft.SqlServer.Management.Smo.ScriptingOptions  
$scOps.Triggers = $TRUE  

Remarks

This option applies only when scripting a SQL Server table.

Applies to