This topic has not yet been rated - Rate this topic

ScriptingOptions.NoCommandTerminator Property

Gets or sets the Boolean property value that specifies whether individual Transact-SQL statements are delimited in the generated script.

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

Syntax

C++

JScript

Copy


public bool NoCommandTerminator { get; set; }

Property Value

Type: System.Boolean
A Boolean value that specifies whether individual Transact-SQL statements are delimited in the generated script.If True, individual Transact-SQL statements are not delimited in the generated script.If False (default), individual Transact-SQL statements are delimited by using the connection-specific command terminator.

Examples

The following code example specifies that individual Transact-SQL statements will not be delimited.

Visual Basic

Copy

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

PowerShell

Copy

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

Reference

ScriptingOptions Class

Microsoft.SqlServer.Management.Smo Namespace

Other Resources

Scripting

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Content Add

FAQ