ScriptingOptions.NoViewColumns ScriptingOptions.NoViewColumns ScriptingOptions.NoViewColumns Property

Definition

Gets or sets the Boolean property value that specifies whether to include the specified columns for a view.

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

A Boolean value that specifies whether to include the specified columns for a view.

If True, the columns for a view are not included in the generated script. Otherwise, False (default).

Examples

The following code example specifies that columns in a view will not be scripted.

Visual Basic

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

PowerShell

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

Remarks

View columns are recorded at the time of the view creation, either by specifying these, or as defined by the SELECT statement.

Applies to