ScriptingOptions Constructor

Initializes a new instance of the ScriptingOptions class.

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

Syntax

'Declaration
Public Sub New
'Usage
Dim instance As New ScriptingOptions()

public ScriptingOptions()

public:
ScriptingOptions()

new : unit -> ScriptingOptions

public function ScriptingOptions()

Remarks

The default constructor initializes any fields to their default values.

Examples

The following code example creates a new instance of the ScriptingOptions class and uses it to configure a Scripter.

Visual Basic

Dim srv As Server
srv = New Server
Dim scriptingOptions As ScriptingOptions
scriptingOptions = New ScriptingOptions
scriptingOptions.ScriptDrops = false
scriptingOptions.WithDependencies = true
Dim scrp As Scripter
scrp = New Scripter(srv)
scrp.Options = scriptingOptions

PowerShell

$srv = New-Object Microsoft.SqlServer.Management.Smo.Server("(local)")
$scriptingOptions = New-Object Microsoft.SqlServer.Management.Smo.ScriptingOptions
$scriptingOptions.ScriptDrops = $FALSE
$scriptingOptions.WithDependencies = $TRUE
$scrp = New-Object Microsoft.SqlServer.Management.Smo.Scripter($srv)
$scrp.Options = $scriptingOptions

See Also

Reference

ScriptingOptions Class

ScriptingOptions Overload

Microsoft.SqlServer.Management.Smo Namespace

Other Resources

Scripting