Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

ScriptOptions Class

Visual Studio 2010

Provides programmatic options that can be set for scripting operations.

System.Object
  Microsoft.SqlServerCe.Management.Scripting.ScriptOptions

Namespace:  Microsoft.SqlServerCe.Management.Scripting
Assembly:  Microsoft.SqlServerCe.Management.Scripting (in Microsoft.SqlServerCe.Management.Scripting.dll)

public final class ScriptOptions

The ScriptOptions type exposes the following members.

  NameDescription
Public methodScriptOptions()Initializes a new instance of the ScriptOptions class using default values.
Public methodScriptOptions(ScriptOptions)Initializes a new instance of the ScriptOptions class with the specified script options.
Top

  NameDescription
Public propertyAnsiPaddingGets 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 propertyAppendToFileGets or sets a value that indicates whether the script is appended to the end of the output file or overwrites it.
Public propertyContinueScriptingOnErrorGets or sets a value that indicates whether the scripting operation continues after an error is encountered.
Public propertyConvertIndexToClusteredIndexGets or sets a value that indicates whether to convert an index to a clustered index.
Public propertyDriAllGets or sets a value that indicates whether all DRI objects are included in the generated script.
Public propertyDriAllConstraintsGets or sets a value that indicates whether all declarative referential integrity constraints are included in the generated script.
Public propertyDriAllKeysGets or sets a value that indicates whether the dependency relationships defined by all declarative referential integrity keys are included in the generated script.
Public propertyDriDefaultsGets or sets a value that indicates whether dependency relationships defined in defaults with enforced declarative referential integrity are included in the script.
Public propertyDriForeignKeysGets or sets a value that indicates whether dependency relationships defined in foreign keys with enforced declarative referential integrity are included in the script.
Public propertyDriPrimaryKeyGets 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 propertyDriUniqueKeysGets 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 propertyEncodingGets or sets the encoding for the scripting options.
Public propertyFileNameGets or sets the name of the file to which the generated script is output.
Public propertyImageToVarBinaryMaxGets or sets a value that indicates whether to convert images to VarBinaryMax.
Public propertyIncludeDatabaseContextGets or sets a value that indicates whether database content is included in the generated script.
Public propertyIncludeHeadersGets 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 propertyIncludeIfNotExistsGets or sets a value that indicates whether to check the existence of an object before including it in the script.
Public propertyIndexesGets or sets a value that indicates whether indexes are included in the generated script.
Public propertyNoCollationGets or sets a value that indicates whether to include the collation clause in the generated script.
Public propertyNoCommandTerminatorGets or sets a value that indicates whether individual Transact-SQL statements are delimited in the generated script.
Public propertyNoIdentitiesGets or sets a value that indicates whether definitions of identity property seed and increment are included in the generated script.
Public propertyNTextToNVarCharMaxGets or sets a value that indicates whether to convert NText values to NVarCharMax.
Public propertyPrefixTableNameToConstraintNameGets or sets a value that indicates whether to prefix table names to constraint names.
Public propertyPrimaryObjectGets or sets a value that indicates whether the creation of the referenced object is included in the generated script.
Public propertySchemaQualifyGets or sets a value that indicates whether the schemas associated with objects are included in the generated script.
Public propertySchemaQualifyForeignKeysReferencesGets or sets a value that indicates whether schema-qualified table references for foreign key constraints are included in the generated script.
Public propertyScriptDataGets or sets a value that indicates whether the ScriptData property is included in the generated script.
Public propertyScriptDropsGets or sets a value that indicates whether the script operation generates a Transact-SQL script to remove the referenced component.
Public propertyScriptSchemaGets or sets a value that indicates whether the ScriptSchema property is included in the generated script.
Public propertyTargetDatabaseEngineTypeGets or sets the target database engine type.
Public propertyTargetServerVersionGets or sets the version of the instance of SQL Server for which the generated script is intended.
Public propertyTimestampToBinaryGets 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 propertyToFileOnlyGets or sets a value that indicates whether to output to file only or to also generate string output.
Public propertyWithDependenciesGets or sets a value that indicates whether to include all dependent objects in the generated script.
Top

  NameDescription
Public methodEquals (inherited from Object)
Protected methodFinalize (inherited from Object)
Public methodGetHashCode (inherited from Object)
Public methodGetType (inherited from Object)
Protected methodMemberwiseClone (inherited from Object)
Public methodToString (inherited from Object)
Top

Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.
Show:
© 2015 Microsoft