Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
SchemaQualify Property
Collapse the table of content
Expand the table of content

ScriptingOptions::SchemaQualify Property

Gets or sets the Boolean property value that specifies whether the schemas associated with objects are included in the generated script.

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

property bool SchemaQualify {
	bool get ();
	void set (bool value);

Property Value

Type: Boolean
A Boolean value that specifies whether objects that have no schema are included in the generated script.If True, objects with no schema are not included in the generated script. Otherwise, False (default).

"All permissions" includes server permissions, database permissions, and object permissions.

The following code example specifies objects with no defined schema will not be scripted.

Visual Basic

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


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

Community Additions

© 2015 Microsoft