ScriptingOptions.IncludeIfNotExists ScriptingOptions.IncludeIfNotExists ScriptingOptions.IncludeIfNotExists Property

Definition

Gets or sets a Boolean property value that specifies whether to check the existence of an object before including it in the script.

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

A Boolean value that specifies whether to check the existence of an object before including it in the script.

If True, the existence of an object is verified before including it in the script. Otherwise, False (default).

Examples

The following code example specifies that the script will verify the existence of an object before including it in the script.

Visual Basic

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

PowerShell

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

Remarks

Creation script for the object is generated only when it does not already exist.

Applies to