.png)
ScriptingOptions.Bindings Property
Gets or sets a Boolean property value that specifies whether the binding statements sp_binddefault and sp_bindrule are included in the generated script. This property applies only when scripting a SQL Server table.
Assembly: Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)
Property Value
Type: System.BooleanA Boolean value that specifies whether the binding statements sp_binddefault and sp_bindrule are included in the generated Transact-SQL script.
If True, binding statements are included in the script. Otherwise, False (default).
The following code example specifies that the sp_binddefault and sp_bindrule binding statements are included in the script.
Visual Basic
Dim scOps As New ScriptingOptions() scOps.Bindings = true
PowerShell
$scOps = New-Object Microsoft.SqlServer.Management.Smo.ScriptingOptions $scOps.Bindings = $TRUE
