Export (0) Print
Expand All

ScriptingOptions Properties

 

Applies To: SQL Server 2016 Preview

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

NameDescription
System_CAPS_pubpropertyAgentAlertJob

Gets or sets the Boolean property that specifies whether to include SQL Server Agent job name for alert objects in the script.

System_CAPS_pubpropertyAgentJobId

Gets or sets the Boolean property that specifies whether to include SQL Server Agent job ID values for alert objects in the script.

System_CAPS_pubpropertyAgentNotify

Gets or sets the Boolean property that specifies whether to include notifications for any SQL Server Agent alerts that are in the script.

System_CAPS_pubpropertyAllowSystemObjects

Gets or sets the Boolean property that specifies whether system objects can be scripted.

System_CAPS_pubpropertyAnsiFile

Gets or sets the Boolean property that specifies whether the script uses multibyte characters and requires code page 1252 to evaluate characters' meaning.

System_CAPS_pubpropertyAnsiPadding

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.

System_CAPS_pubpropertyAppendToFile

Gets or sets a Boolean property value that specifies whether the script is appended to the end of the output file or overwrites it.

System_CAPS_pubpropertyBatchSize

Gets or sets the number of statements after which to script batch terminator.

System_CAPS_pubpropertyBindings

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.

System_CAPS_pubpropertyChangeTracking

Gets or sets whether the ScriptingOptions tracking changes.

System_CAPS_pubpropertyClusteredIndexes

Gets or sets a Boolean property value that specifies whether statements that define clustered indexes are included in the generated script.

System_CAPS_pubpropertyContinueScriptingOnError

Gets or sets the Boolean property value that specifies whether the scripting operation continues after an error is encountered.

System_CAPS_pubpropertyConvertUserDefinedDataTypesToBaseType

Gets or sets the Boolean property value that specifies whether user-defined data types are converted to the most appropriate SQL Server base data types in the generated script.

System_CAPS_pubpropertyDdlBodyOnly

Gets or sets the Boolean property value that specifies whether to script only the text definition for data definition language (DDL) objects that have a text body, such as stored procedures and triggers.

System_CAPS_pubpropertyDdlHeaderOnly

Gets or sets the Boolean property value that specifies whether to script only the header information for data definition language (DDL) objects that have a text body, such as stored procedures and triggers.

System_CAPS_pubpropertyDefault

Gets or sets the Boolean property value that specifies whether the creation of the referenced object is included in the generated script.

System_CAPS_pubpropertyDriAll

Gets or sets the Boolean property value that specifies whether all DRI objects are included in the generated script.

System_CAPS_pubpropertyDriAllConstraints

Gets or sets the Boolean property value that specifies whether all declarative referential integrity constraints are included in the generated script.

System_CAPS_pubpropertyDriAllKeys

Gets or sets the Boolean property value that specifies whether the dependency relationships defined by all declarative referential integrity keys are included in the generated script.

System_CAPS_pubpropertyDriChecks

Gets or sets the Boolean property value that specifies whether column specific dependency relationships as defined in check constraints with enforced declarative referential integrity are included in the script.

System_CAPS_pubpropertyDriClustered

Gets or sets the Boolean property value that specifies whether dependency relationships defined in clustered indexes with enforced declarative referential integrity are included in the script.

System_CAPS_pubpropertyDriDefaults

Gets or sets the Boolean property value that specifies whether dependency relationships defined in defaults with enforced declarative referential integrity are included in the script.

System_CAPS_pubpropertyDriForeignKeys

Gets or sets the Boolean property value that specifies whether dependency relationships defined in foreign keys with enforced declarative referential integrity are included in the script.

System_CAPS_pubpropertyDriIncludeSystemNames

Gets or sets the Boolean property value that specifies whether the system-generated constraint names that are used to enforce declarative referential integrity are included in the script.

System_CAPS_pubpropertyDriIndexes

Gets or sets the Boolean property value that specifies whether PRIMARY KEY constraints that use a unique index to implement the declarative referential integrity are included in the script.

System_CAPS_pubpropertyDriNonClustered

Gets or sets the Boolean property value that specifies whether dependency relationships that are defined in non-clustered indexes that have enforced declarative referential integrity are included in the script.

System_CAPS_pubpropertyDriPrimaryKey

Gets or sets the Boolean property value that specifies whether dependency relationships that are defined in primary keys which have enforced declarative referential integrity are included in the script.

System_CAPS_pubpropertyDriUniqueKeys

Gets or sets the Boolean property value that specifies whether dependency relationships that are defined in unique keys which have enforced declarative referential integrity are included in the script.

System_CAPS_pubpropertyDriWithNoCheck

Gets or sets the Boolean property value that specifies whether the no check statement is included in the script.

System_CAPS_pubpropertyEncoding

Gets or sets the encoding for the scripting options.

System_CAPS_pubpropertyEnforceScriptingOptions

Gets or sets the Boolean property value that specifies whether the application of all scripting options is enforced for text-based objects, such as SchemaQualify.

System_CAPS_pubpropertyExtendedProperties

Gets or sets the Boolean property value that specifies whether extended object properties are included in the generated script.

System_CAPS_pubpropertyFileName

Gets or sets the name of the file to which the generated script is output.

System_CAPS_pubpropertyFullTextCatalogs

Gets or sets the Boolean property value that specifies whether full-text catalogs are included in the generated script.

System_CAPS_pubpropertyFullTextIndexes

Gets or sets the Boolean property value that specifies whether full-text indexes are included in the generated script.

System_CAPS_pubpropertyFullTextStopLists

Gets or sets the Boolean property value that specifies whether full-text stop lists are included in the generated script.

System_CAPS_pubpropertyIncludeDatabaseContext

Gets or sets the Boolean property value that specifies whether database context is included in the generated script.

System_CAPS_pubpropertyIncludeDatabaseRoleMemberships

Gets or sets a value that indicates whether the database role memberships are included.

System_CAPS_pubpropertyIncludeFullTextCatalogRootPath

Gets or sets a value that indicates whether the full text catalog root path is included.

System_CAPS_pubpropertyIncludeHeaders

Gets or sets a Boolean property value that specifies whether the generated script is prefixed with a header that contains information which includes the date and time of generation.

System_CAPS_pubpropertyIncludeIfNotExists

Gets or sets a Boolean property value that specifies whether to check the existence of an object before including it in the script.

System_CAPS_pubpropertyIndexes

Gets or sets the Boolean property value that specifies whether indexes are included in the generated script.

System_CAPS_pubpropertyLoginSid

Gets or sets the Boolean property value that specifies whether the security identifiers are included for any scripted logins in the generated script.

System_CAPS_pubpropertyNoAssemblies

Gets or sets the Boolean property value that specifies whether assemblies are included in the generated script.

System_CAPS_pubpropertyNoCollation

Gets or sets the Boolean property value that specifies whether to include the collation clause in the generated script.

System_CAPS_pubpropertyNoCommandTerminator

Gets or sets the Boolean property value that specifies whether individual Transact-SQL statements are delimited in the generated script.

System_CAPS_pubpropertyNoExecuteAs

Gets or sets the Boolean property value that specifies whether the EXECUTE AS options for stored procedures and user-defined functions are included in the script.

System_CAPS_pubpropertyNoFileGroup

Gets or sets the Boolean property value that specifies whether to include the 'ON <filegroup>' clause in the generated script.

System_CAPS_pubpropertyNoFileStream

Gets or sets an object that specifies whether to include the FILESTREAM_ON clause when you create VarBinaryMax columns in the generated script.

System_CAPS_pubpropertyNoFileStreamColumn

Gets or sets an object that specifies whether to include the FILESTREAM_ON clause when you create VarBinaryMax columns in the generated script.

System_CAPS_pubpropertyNoIdentities

Gets or sets the Boolean property value that specifies whether definitions of identity property seed and increment are included in the generated script.

System_CAPS_pubpropertyNoIndexPartitioningSchemes

Gets or sets the Boolean property value that specifies whether partition schemes for indexes are included in the generated script.

System_CAPS_pubpropertyNoMailProfileAccounts

Gets or sets the Boolean property value that specifies whether mail accounts that are referenced by mail profiles are included in the generated script.

System_CAPS_pubpropertyNoMailProfilePrincipals

Gets or sets the Boolean property value that specifies whether principals that are referenced by mail profiles are included in the generated script.

System_CAPS_pubpropertyNonClusteredIndexes

Gets or sets the Boolean property value that specifies whether non-clustered indexes are included in the generated script.

System_CAPS_pubpropertyNoTablePartitioningSchemes

Gets or sets the Boolean property value that specifies whether partition schemes for tables are included in the generated script.

System_CAPS_pubpropertyNoVardecimal

Gets or sets an object that specifies whether to include the N clause when you create vardecimal columns in the generated script.

System_CAPS_pubpropertyNoViewColumns

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

System_CAPS_pubpropertyNoXmlNamespaces

Gets or sets the Boolean property value that specifies whether XML namespaces are included in the generated script.

System_CAPS_pubpropertyOptimizerData

Gets or sets the Boolean property value that specifies whether script optimizer data for the referenced objects are included in the generated script.

System_CAPS_pubpropertyPermissions

Gets or sets the Boolean property value that specifies whether to include all permissions in the generated script.

System_CAPS_pubpropertyPrimaryObject

Gets or sets the Boolean property value that specifies whether the creation of the referenced object is included in the generated script.

System_CAPS_pubpropertySchemaQualify

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

System_CAPS_pubpropertySchemaQualifyForeignKeysReferences

Gets or sets the Boolean property value that specifies whether schema-qualified table references for foreign key constraints are included in the generated script.

System_CAPS_pubpropertyScriptBatchTerminator

Gets or sets the ScriptBatchTerminator property value.

System_CAPS_pubpropertyScriptData

Gets or sets the ScriptData property value.

System_CAPS_pubpropertyScriptDataCompression

Gets or sets the Boolean property value that specifies whether to include data compression information in the generated script.

System_CAPS_pubpropertyScriptDrops

Gets or sets the Boolean property value that specifies whether the script operation generates a Transact-SQL script to remove the referenced component.

System_CAPS_pubpropertyScriptOwner

Gets or sets the Boolean property value that specifies whether the script owner is included in the generated script.

System_CAPS_pubpropertyScriptSchema

Gets or set the ScriptSchema property value.

System_CAPS_pubpropertyStatistics

Gets or sets the Boolean property value that specifies whether to include statistics for any table or view that is included in the generated script.

System_CAPS_pubpropertyTargetDatabaseEngineType

Gets or sets the DatabaseEngineType property value.

System_CAPS_pubpropertyTargetServerVersion

Gets or sets the version of the instance of SQL Server for which the generated script is intended.

System_CAPS_pubpropertyTimestampToBinary

Gets or sets the Boolean property value that specifies whether to convert timestamp data types to binary(8) data types when scripting the creation of a table or user-defined data type.

System_CAPS_pubpropertyToFileOnly

Gets or sets the Boolean property value that specifies whether to output to file only or to also generate string output.

System_CAPS_pubpropertyTriggers

Gets or sets the Boolean property value that specifies whether to include the definition for triggers in the generated script.

System_CAPS_pubpropertyWithDependencies

Gets or sets the Boolean property value that specifies whether to include all dependent objects in the generated script.

System_CAPS_pubpropertyXmlIndexes

Gets or sets the Boolean property value that specifies whether XML indexes are included in the generated script.

Return to top
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2015 Microsoft