• Article

ScriptingOptions.AnsiPadding Property

Gets or sets a Boolean property that specifies whether the generated script contains the Transact-SQL statements SET ANSI-PADDING ON and SET ANSI-PADDING OFF before and after the CREATE TABLE statement, respectively.

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

Syntax

'Declaration
Public Property AnsiPadding As Boolean
    Get
    Set
'Usage
Dim instance As ScriptingOptions
Dim value As Boolean

value = instance.AnsiPadding

instance.AnsiPadding = value

public bool AnsiPadding { get; set; }

public:
property bool AnsiPadding {
    bool get ();
    void set (bool value);
}

member AnsiPadding : bool with get, set

function get AnsiPadding () : boolean
function set AnsiPadding (value : boolean)

Property Value

Type: System.Boolean
A Boolean value that specifies whether the ANSI padding statements are included in the generated script.
If True, the generated script contains the Transact-SQL statements SET ANSI-PADDING ON and SET ANSI-PADDING OFF before and after the CREATE TABLE statement respectively. Otherwise, False (default).

Examples

Scripting