ScriptOptions Properties

ScriptOptions Properties

Visual Studio 2010

The ScriptOptions type exposes the following members.

  Name Description
Public property AnsiPadding Gets or sets a value that indicates 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.
Public property AppendToFile Gets or sets a value that indicates whether the script is appended to the end of the output file or overwrites it.
Public property ContinueScriptingOnError Gets or sets a value that indicates whether the scripting operation continues after an error is encountered.
Public property ConvertIndexToClusteredIndex Gets or sets a value that indicates whether to convert an index to a clustered index.
Public property DriAll Gets or sets a value that indicates whether all DRI objects are included in the generated script.
Public property DriAllConstraints Gets or sets a value that indicates whether all declarative referential integrity constraints are included in the generated script.
Public property DriAllKeys Gets or sets a value that indicates whether the dependency relationships defined by all declarative referential integrity keys are included in the generated script.
Public property DriDefaults Gets or sets a value that indicates whether dependency relationships defined in defaults with enforced declarative referential integrity are included in the script.
Public property DriForeignKeys Gets or sets a value that indicates whether dependency relationships defined in foreign keys with enforced declarative referential integrity are included in the script.
Public property DriPrimaryKey Gets or sets a value that indicates whether dependency relationships that are defined in primary keys which have enforced declarative referential integrity are included in the script.
Public property DriUniqueKeys Gets or sets a value that indicates whether dependency relationships that are defined in unique keys which have enforced declarative referential integrity are included in the script.
Public property Encoding Gets or sets the encoding for the scripting options.
Public property FileName Gets or sets the name of the file to which the generated script is output.
Public property ImageToVarBinaryMax Gets or sets a value that indicates whether to convert images to VarBinaryMax.
Public property IncludeDatabaseContext Gets or sets a value that indicates whether database content is included in the generated script.
Public property IncludeHeaders Gets or sets a value that indicates whether the generated script is prefixed with a header that contains information which includes the date and time of generation.
Public property IncludeIfNotExists Gets or sets a value that indicates whether to check the existence of an object before including it in the script.
Public property Indexes Gets or sets a value that indicates whether indexes are included in the generated script.
Public property NoCollation Gets or sets a value that indicates whether to include the collation clause in the generated script.
Public property NoCommandTerminator Gets or sets a value that indicates whether individual Transact-SQL statements are delimited in the generated script.
Public property NoIdentities Gets or sets a value that indicates whether definitions of identity property seed and increment are included in the generated script.
Public property NTextToNVarCharMax Gets or sets a value that indicates whether to convert NText values to NVarCharMax.
Public property PrefixTableNameToConstraintName Gets or sets a value that indicates whether to prefix table names to constraint names.
Public property PrimaryObject Gets or sets a value that indicates whether the creation of the referenced object is included in the generated script.
Public property SchemaQualify Gets or sets a value that indicates whether the schemas associated with objects are included in the generated script.
Public property SchemaQualifyForeignKeysReferences Gets or sets a value that indicates whether schema-qualified table references for foreign key constraints are included in the generated script.
Public property ScriptData Gets or sets a value that indicates whether the ScriptData property is included in the generated script.
Public property ScriptDrops Gets or sets a value that indicates whether the script operation generates a Transact-SQL script to remove the referenced component.
Public property ScriptSchema Gets or sets a value that indicates whether the ScriptSchema property is included in the generated script.
Public property TargetDatabaseEngineType Gets or sets the target database engine type.
Public property TargetServerVersion Gets or sets the version of the instance of SQL Server for which the generated script is intended.
Public property TimestampToBinary Gets or sets a value that indicates whether to convert timestamp data types to binary8 data types when scripting the creation of a table or user-defined data type.
Public property ToFileOnly Gets or sets a value that indicates whether to output to file only or to also generate string output.
Public property WithDependencies Gets or sets a value that indicates whether to include all dependent objects in the generated script.
Top
Show:
© 2016 Microsoft