ScriptingOptions.IncludeIfNotExists Property
SQL Server 2012
Gets or sets a Boolean property value that specifies whether to check the existence of an object before including it in the script.
Namespace: Microsoft.SqlServer.Management.Smo
Assembly: Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)
Property Value
Type: System.BooleanA 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).
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
