Export (0) Print
Expand All

IScriptingOptions Interface

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

The IScriptingOptions type exposes the following members.

  NameDescription
Public propertyBatchSeparatorGets a value that separates script into batches.
Public propertyConvertUddtToBaseTypeGets a value indicating whether user-defined data types are converted to the most appropriate SQL Server base data types in the generated script.
Public propertyDelimitStatementsGets the specified limitation of a statement.
Public propertyGenerateAnsiPaddingGets a value indicating whether the script generates ANSI-PADDING.
Public propertyIncludeCollationGets a value indicating whether to include the collation clause in the generated script.
Public propertyIncludeHeadersGets a value indicating whether the script contains a header that includes the date and time generation.
Public propertyIncludeIdentityGets a value indicating whether the definitions of the identity property seed and increment are included in the generated script.
Public propertyIncludeIfNotExistsGets a value indicating whether to check if an object doesn't exist before including it in the script.
Public propertyIncludeVarDecimalGets a value indicating whether to include the N clause when you create VarDecimal columns in the generated script.
Public propertySchemaQualifyGets a value indicating whether the script contains an object with a qualified schema.
Public propertySchemaQualifyForeignKeysGets a value indicating whether an object with no schema that is referenced by a foreign key are included in the generated script.
Public propertyScriptBindingGets a value indicating whether the binding of the script is included.
Public propertyScriptChangeTrackingGets a value indicating whether the script includes the change tracking information.
Public propertyScriptCheckConstraintsGets a value indicating whether the constraints in the script are checked.
Public propertyScriptDataCompressionOptionsGets a value indicating whether to include data compression options in the generated script.
Public propertyScriptDefaultsGets a value indicating whether the creation of the referenced object is included in the generated script.
Public propertyScriptDependentObjectsGets a value indicating whether a script is generated for the additional objects that are required when the script for the selected object is executed.
Public propertyScriptDriIncludeSystemNamesGets a value indicating whether the script includes the system-generated constraint names to enforce declarative referential integrity.
Public propertyScriptExtendedPropertiesGets a value indicating whether the script includes the extended properties.
Public propertyScriptFileGroupsGets a value indicating whether the script specifies the file groups.
Public propertyScriptForeignKeysGets a value indicating whether the script includes the foreign key constraints.
Public propertyScriptFullTextCatalogsGets a value indicating whether the script includes the full-text catalogs.
Public propertyScriptFullTextIndexesGets a value indicating whether the script includes the full-text indexes.
Public propertyScriptIndexesGets a value indicating whether the script includes the clustered, non-clustered, and XML indexes.
Public propertyScriptOwnerGets a value indicating whether the owner of the script is included.
Public propertyScriptPartitionSchemesGets a value indicating whether the script includes the table partitioning schemes.
Public propertyScriptPermissionsGets a value indicating whether the script includes the permissions on database objects.
Public propertyScriptPrimaryKeysGets a value indicating whether the script includes the primary key constraints.
Public propertyScriptStatisticsGets a value indicating whether the script includes the user-defined statistics.
Public propertyScriptTriggersGets a value indicating whether to include the definition for triggers in the generated script.
Public propertyScriptUniqueKeysGets a value indicating whether the script includes the unique constraints.
Public propertyScriptUseDatabaseGets a value indicating whether the script adds the use database statement to create database objects in the context of the current object explorer database.
Public propertyScriptViewColumnsGets a value indicating whether the script declares view columns in view headers in the script.
Public propertyTargetDatabaseEngineTypeGets the DatabaseEngineType property value.
Public propertyTargetVersionGets the version for which the generated script is intended.
Top

  NameDescription
Public methodGetSmoScriptingOptionsRetrieves the collections of objects from the scripting options.
Top
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft