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)
Syntax
'Declaration
Public Interface IScriptingOptions
'Usage
Dim instance As IScriptingOptions
public interface IScriptingOptions
public interface class IScriptingOptions
type IScriptingOptions = interface end
public interface IScriptingOptions
The IScriptingOptions type exposes the following members.
Properties
Name | Description | |
---|---|---|
![]() |
BatchSeparator | Gets a value that separates script into batches. |
![]() |
ConvertUddtToBaseType | Gets a value indicating whether user-defined data types are converted to the most appropriate SQL Server base data types in the generated script. |
![]() |
DelimitStatements | Gets the specified limitation of a statement. |
![]() |
GenerateAnsiPadding | Gets a value indicating whether the script generates ANSI-PADDING. |
![]() |
IncludeCollation | Gets a value indicating whether to include the collation clause in the generated script. |
![]() |
IncludeHeaders | Gets a value indicating whether the script contains a header that includes the date and time generation. |
![]() |
IncludeIdentity | Gets a value indicating whether the definitions of the identity property seed and increment are included in the generated script. |
![]() |
IncludeIfNotExists | Gets a value indicating whether to check if an object doesn't exist before including it in the script. |
![]() |
IncludeVarDecimal | Gets a value indicating whether to include the N clause when you create VarDecimal columns in the generated script. |
![]() |
SchemaQualify | Gets a value indicating whether the script contains an object with a qualified schema. |
![]() |
SchemaQualifyForeignKeys | Gets a value indicating whether an object with no schema that is referenced by a foreign key are included in the generated script. |
![]() |
ScriptBinding | Gets a value indicating whether the binding of the script is included. |
![]() |
ScriptChangeTracking | Gets a value indicating whether the script includes the change tracking information. |
![]() |
ScriptCheckConstraints | Gets a value indicating whether the constraints in the script are checked. |
![]() |
ScriptDataCompressionOptions | Gets a value indicating whether to include data compression options in the generated script. |
![]() |
ScriptDefaults | Gets a value indicating whether the creation of the referenced object is included in the generated script. |
![]() |
ScriptDependentObjects | 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. |
![]() |
ScriptDriIncludeSystemNames | Gets a value indicating whether the script includes the system-generated constraint names to enforce declarative referential integrity. |
![]() |
ScriptExtendedProperties | Gets a value indicating whether the script includes the extended properties. |
![]() |
ScriptFileGroups | Gets a value indicating whether the script specifies the file groups. |
![]() |
ScriptForeignKeys | Gets a value indicating whether the script includes the foreign key constraints. |
![]() |
ScriptFullTextCatalogs | Gets a value indicating whether the script includes the full-text catalogs. |
![]() |
ScriptFullTextIndexes | Gets a value indicating whether the script includes the full-text indexes. |
![]() |
ScriptIndexes | Gets a value indicating whether the script includes the clustered, non-clustered, and XML indexes. |
![]() |
ScriptPartitionSchemes | Gets a value indicating whether the script includes the table partitioning schemes. |
![]() |
ScriptPermissions | Gets a value indicating whether the script includes the permissions on database objects. |
![]() |
ScriptPrimaryKeys | Gets a value indicating whether the script includes the primary key constraints. |
![]() |
ScriptStatistics | Gets a value indicating whether the script includes the user-defined statistics. |
![]() |
ScriptTriggers | Gets a value indicating whether to include the definition for triggers in the generated script. |
![]() |
ScriptUniqueKeys | Gets a value indicating whether the script includes the unique constraints. |
![]() |
ScriptUseDatabase | 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. |
![]() |
ScriptViewColumns | Gets a value indicating whether the script declares view columns in view headers in the script. |
![]() |
TargetDatabaseEngineType | Gets the DatabaseEngineType property value. |
![]() |
TargetVersion | Gets the version for which the generated script is intended. |
Top
Methods
Name | Description | |
---|---|---|
![]() |
GetSmoScriptingOptions | Retrieves the collections of objects from the scripting options. |
Top