SQL Server
United States (English) Sign in
Home 2012 2008 R2 2008 Previous Versions Library Forums
TechNet Library
SQL Server
SQL Server 2008 R2
Product Documentation
SQL Server 2008 R2 Books Online
Database Engine
Technical Reference
SQL Server Management Objects (SMO) Class Library
Microsoft.SqlServer.Management.Smo Namespace
ScriptingOptions Class
ScriptingOptions Properties
AgentAlertJob Property
AgentJobId Property
AgentNotify Property
AllowSystemObjects Property
AnsiFile Property
AnsiPadding Property
AppendToFile Property
BatchSize Property
Bindings Property
ChangeTracking Property
ClusteredIndexes Property
ContinueScriptingOnError Property
ConvertUserDefinedDataTypesToBaseType Property
DdlBodyOnly Property
DdlHeaderOnly Property
Default Property
DriAll Property
DriAllConstraints Property
DriAllKeys Property
DriChecks Property
DriClustered Property
DriDefaults Property
DriForeignKeys Property
DriIncludeSystemNames Property
DriIndexes Property
DriNonClustered Property
DriPrimaryKey Property
DriUniqueKeys Property
DriWithNoCheck Property
Encoding Property
EnforceScriptingOptions Property
ExtendedProperties Property
FileName Property
FullTextCatalogs Property
FullTextIndexes Property
FullTextStopLists Property
IncludeDatabaseContext Property
IncludeDatabaseRoleMemberships Property
IncludeFullTextCatalogRootPath Property
IncludeHeaders Property
IncludeIfNotExists Property
Indexes Property
LoginSid Property
NoAssemblies Property
NoCollation Property
NoCommandTerminator Property
NoExecuteAs Property
NoFileGroup Property
NoFileStream Property
NoFileStreamColumn Property
NoIdentities Property
NoIndexPartitioningSchemes Property
NoMailProfileAccounts Property
NoMailProfilePrincipals Property
NonClusteredIndexes Property
NoTablePartitioningSchemes Property
NoVardecimal Property
NoViewColumns Property
NoXmlNamespaces Property
OptimizerData Property
Permissions Property
PrimaryObject Property
SchemaQualify Property
SchemaQualifyForeignKeysReferences Property
ScriptBatchTerminator Property
ScriptData Property
ScriptDataCompression Property
ScriptDrops Property
ScriptOwner Property
ScriptSchema Property
Statistics Property
TargetDatabaseEngineType Property
TargetServerVersion Property
TimestampToBinary Property
ToFileOnly Property
Triggers Property
WithDependencies Property
XmlIndexes Property
Expand Minimize
This topic has not yet been rated - Rate this topic

ScriptingOptions.AnsiPadding Property

SQL Server 2008 R2

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)
C#
C++
F#
JScript
VB
Copy 
public bool AnsiPadding { get; set; }

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).

The following code example specifies that the script uses ANSI padding statements.

Visual Basic

Copy 
Dim scOps As New ScriptingOptions()
scOps.AnsiPadding = true

PowerShell

Copy 
$scOps = New-Object Microsoft.SqlServer.Management.Smo.ScriptingOptions
$scOps.AnsiPadding = $TRUE
Did you find this helpful?
(1500 characters remaining)

Community Additions

ADD
© 2013 Microsoft
|
Site Feedback
© 2013 Microsoft. All rights reserved.