The ScriptType and Script2Type properties configure the Transact-SQL script generated and used to copy database schema in a transfer of schema from one database to another.
object.ScriptType [= value]
object
Expression that evaluates to an object in the Applies To list
value
Long integer that specifies script generation options as described in Settings
Long, enumerated
Read/write
HRESULT GetScriptType(SQLDMO_SCRIPT_TYPE* pRetVal);
HRESULT SetScriptType(SQLDMO_SCRIPT_TYPE NewValue);
| Constant | Value | Description |
|---|---|---|
| SQLDMOScript_Bindings | 128 | Generate sp_bindefault and sp_bindrule statements. Applies only when scripting references a Microsoft® SQL Server™ 2000 table. |
| SQLDMOScript_ClusteredIndexes | 8 | Generate Transact-SQL defining clustered indexes. Applies only when scripting references a SQL Server table. |
| SQLDMOScript_DatabasePermissions | 32 | Generate Transact-SQL database privilege defining script. Database permissions grant or deny statement execution rights. |
| SQLDMOScript_DRI_All | 532676608 | All values defined as SQLDMOScript_DRI_... combined using an OR logical operator. |
| SQLDMOScript_DRI_AllConstraints | 520093696 | SQLDMOScript_DRI_Checks, SQLDMOScript_DRI_Defaults, SQLDMOScript_DRI_ForeignKeys, SQLDMOScript_DRI_PrimaryKey, and SQLDMOScript_DRI_UniqueKeys combined using an OR logical operator. |
| SQLDMOScript_DRI_AllKeys | 469762048 | SQLDMOScript_DRI_ForeignKeys, SQLDMOScript_DRI_PrimaryKey, SQLDMOScript_DRI_UniqueKeys combined using an OR logical operator. |
| SQLDMOScript_DRI_Checks | 16777216 | Generated script creates column-specified CHECK constraints. Directs scripting when declarative referential integrity establishes dependency relationships. Applies only when scripting references a SQL Server table. |
| SQLDMOScript_DRI_Clustered | 8388608 | Generated script creates clustered indexes. Directs scripting when declarative referential integrity establishes dependency relationships. Applies only when scripting references a SQL Server table. |
| SQLDMOScript_DRI_Defaults | 33554432 | Generated script includes column-specified defaults. Directs scripting when declarative referential integrity establishes dependency relationships. Applies only when scripting references a SQL Server table. |
| SQLDMOScript_DRI_ForeignKeys | 134217728 | Generated script creates FOREIGN KEY constraints. Directs scripting when declarative referential integrity establishes dependency relationships. Applies only when scripting references a SQL Server table. |
| SQLDMOScript_DRI_NonClustered | 4194304 | Generated script creates nonclustered indexes. Directs scripting when declarative referential integrity establishes dependency relationships. Applies only when scripting references a SQL Server table. |
| SQLDMOScript_DRI_PrimaryKey | 268435456 | Generated script creates PRIMARY KEY constraints. Directs scripting when declarative referential integrity establishes dependency relationships. Applies only when scripting references a SQL Server table. |
| SQLDMOScript_DRI_UniqueKeys | 67108864 | Generated script creates candidate keys defined using a unique index. Directs scripting when declarative referential integrity establishes dependency relationships. Applies only when scripting references a SQL Server table. |
| SQLDMOScript_DRIWithNoCheck | 536870912 | When using SQLDMOScript_DRI_Checks, or SQLDMOScript_DRI_ForeignKeys, generated script includes the WITH NOCHECK clause optimizing constraint creation. Applies only when scripting references a SQL Server table. |
| SQLDMOScript_Drops | 1 | Generate Transact-SQL to remove referenced component. Script tests for existence prior attempt to remove component. |
| SQLDMOScript_IncludeHeaders | 131072 | Generated script is prefixed with a header containing date and time of generation and other descriptive information. |
| SQLDMOScript_IncludeIfNotExists | 4096 | Transact-SQL creating a component is prefixed by a check for existence. When script is executed, component is created only when a copy of the named component does not exist. |
| SQLDMOScript_Indexes | 73736 | SQLDMOScript_ClusteredIndexes, SQLDMOScript_NonClusteredIndexes, and SQLDMOScript_DRIIndexes combined using an OR logical operator. Applies to both table and view objects. |
| SQLDMOScript_NoIdentity | 1073741824 | Generated Transact-SQL statements do not include definition of identity property, seed, and increment. Applies only when scripting references a SQL Server table. |
| SQLDMOScript_NonClusteredIndexes | 8192 | Generate Transact-SQL defining nonclustered indexes. Applies only when scripting references a SQL Server table. |
| SQLDMOScript_ObjectPermissions | 2 | Include Transact-SQL privilege defining statements when scripting database objects. |
| SQLDMOScript_OwnerQualify | 262144 | Object names in Transact-SQL generated to remove an object are qualified by the owner of the referenced object. Transact-SQL qualifies the object name using the current object owner. |
| SQLDMOScript_Permissions | 34 | SQLDMOScript_ObjectPermissions and SQLDMOScript_DatabasePermissions combined using an OR logical operator. |
| SQLDMOScript_PrimaryObject | 4 | Generate Transact-SQL creating the referenced component. |
| SQLDMOScript_TimestampToBinary | 524288 | When scripting object creation for a table or user-defined data type, convert specification of timestamp data type to binary(8). |
| SQLDMOScript_TransferDefault | 422143 | Default. SQLDMOScript_PrimaryObject, SQLDMOScript_Drops,SQLDMOScript_Bindings, SQLDMOScript_ClusteredIndexes, SQLDMOScript_NonClusteredIndexes, SQLDMOScript_Triggers, SQLDMOScript_ToFileOnly, SQLDMOScript_Permissions, SQLDMOScript_IncludeHeaders, SQLDMOScript_Aliases, SQLDMOScript_IncludeIfNotExists, and SQLDMOScript_OwnerQualify combined using an OR logical operator. |
| SQLDMOScript_Triggers | 16 | Generate Transact-SQL defining triggers. Applies only when scripting references a SQL Server table. |
| SQLDMOScript_UDDTsToBaseType | 1024 | Convert specification of user-defined data types to the appropriate SQL Server base data type. Applies only when scripting references a SQL Server table. |
| SQLDMOScript_UseQuotedIdentifiers | -1 | Use quote characters to delimit identifier parts when scripting object names. |
Use the AddObject and AddObjectByName methods of the Transfer object to build a list of SQL Server components copied from one database to another. With the list built, configure component transfer using the ScriptType and Script2Type properties.