Export (0) Print
Expand All

IScriptingOptions Interface

 

Applies To: SQL Server 2016 Preview

Provides programmatic options that can be set for scripting operations.

Namespace:   Microsoft.SqlServer.Management.UI.VSIntegration
Assembly:  SqlWorkbench.Interfaces (in SqlWorkbench.Interfaces.dll)

public interface IScriptingOptions

NameDescription
System_CAPS_pubpropertyBatchSeparator

Gets a value that separates script into batches.

System_CAPS_pubpropertyConvertUddtToBaseType

Gets a value indicating whether user-defined data types are converted to the most appropriate SQL Server base data types in the generated script.

System_CAPS_pubpropertyDelimitStatements

Gets the specified limitation of a statement.

System_CAPS_pubpropertyGenerateAnsiPadding

Gets a value indicating whether the script generates ANSI-PADDING.

System_CAPS_pubpropertyIncludeCollation

Gets a value indicating whether to include the collation clause in the generated script.

System_CAPS_pubpropertyIncludeHeaders

Gets a value indicating whether the script contains a header that includes the date and time generation.

System_CAPS_pubpropertyIncludeIdentity

Gets a value indicating whether the definitions of the identity property seed and increment are included in the generated script.

System_CAPS_pubpropertyIncludeIfNotExists

Gets a value indicating whether to check if an object doesn't exist before including it in the script.

System_CAPS_pubpropertyIncludeVarDecimal

Gets a value indicating whether to include the N clause when you create VarDecimal columns in the generated script.

System_CAPS_pubpropertySchemaQualify

Gets a value indicating whether the script contains an object with a qualified schema.

System_CAPS_pubpropertySchemaQualifyForeignKeys

Gets a value indicating whether an object with no schema that is referenced by a foreign key are included in the generated script.

System_CAPS_pubpropertyScriptBinding

Gets a value indicating whether the binding of the script is included.

System_CAPS_pubpropertyScriptChangeTracking

Gets a value indicating whether the script includes the change tracking information.

System_CAPS_pubpropertyScriptCheckConstraints

Gets a value indicating whether the constraints in the script are checked.

System_CAPS_pubpropertyScriptDataCompressionOptions

Gets a value indicating whether to include data compression options in the generated script.

System_CAPS_pubpropertyScriptDefaults

Gets a value indicating whether the creation of the referenced object is included in the generated script.

System_CAPS_pubpropertyScriptDependentObjects

Gets a value indicating whether a script is generated for the additional objects that are required when the script for the selected object is executed.

System_CAPS_pubpropertyScriptDriIncludeSystemNames

Gets a value indicating whether the script includes the system-generated constraint names to enforce declarative referential integrity.

System_CAPS_pubpropertyScriptExtendedProperties

Gets a value indicating whether the script includes the extended properties.

System_CAPS_pubpropertyScriptFileGroups

Gets a value indicating whether the script specifies the file groups.

System_CAPS_pubpropertyScriptForeignKeys

Gets a value indicating whether the script includes the foreign key constraints.

System_CAPS_pubpropertyScriptFullTextCatalogs

Gets a value indicating whether the script includes the full-text catalogs.

System_CAPS_pubpropertyScriptFullTextIndexes

Gets a value indicating whether the script includes the full-text indexes.

System_CAPS_pubpropertyScriptIndexes

Gets a value indicating whether the script includes the clustered, non-clustered, and XML indexes.

System_CAPS_pubpropertyScriptOwner

Gets a value indicating whether the owner of the script is included.

System_CAPS_pubpropertyScriptPartitionSchemes

Gets a value indicating whether the script includes the table partitioning schemes.

System_CAPS_pubpropertyScriptPermissions

Gets a value indicating whether the script includes the permissions on database objects.

System_CAPS_pubpropertyScriptPrimaryKeys

Gets a value indicating whether the script includes the primary key constraints.

System_CAPS_pubpropertyScriptStatistics

Gets a value indicating whether the script includes the user-defined statistics.

System_CAPS_pubpropertyScriptTriggers

Gets a value indicating whether to include the definition for triggers in the generated script.

System_CAPS_pubpropertyScriptUniqueKeys

Gets a value indicating whether the script includes the unique constraints.

System_CAPS_pubpropertyScriptUseDatabase

Gets a value indicating whether the script adds the use database statement to create database objects in the context of the current object explorer database.

System_CAPS_pubpropertyScriptViewColumns

Gets a value indicating whether the script declares view columns in view headers in the script.

System_CAPS_pubpropertyTargetDatabaseEngineType

Gets the DatabaseEngineType property value.

System_CAPS_pubpropertyTargetVersion

Gets the version for which the generated script is intended.

NameDescription
System_CAPS_pubmethodGetSmoScriptingOptions()

Retrieves the collections of objects from the scripting options.

Return to top
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

Show:
© 2015 Microsoft