Replication Object Creation Script Constants (SQLDMO_CREATIONSCRIPT_TYPE)
This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.
Replication object creation script constants define behavior on initial synchronization script generation. As articles are published, the schema of replicated tables is captured for Subscribers. When a subscription receives the article, the table or object implementing the article is created as specified by creation script constants.
Constant |
Value |
Description |
|---|---|---|
SQLDMOCreationScript_/ClusteredIndexes |
16 |
Includes clustered index creation on tables in the script. |
SQLDMOCreationScript_Collation |
4096 |
Replicates column-level collation. |
SQLDMOCreationScript_/CustomProcs |
2 |
Generates custom stored procedures for the article if defined (transactional replication only). |
SQLDMOCreationScript_/DisableScripting |
0 |
Does not script. |
SQLDMOCreationScript_DRI_Checks |
1024 |
Includes creation of check constraints during creation of tables in the script. |
SQLDMOCreationScript_DRI_/Defaults |
2048 |
Includes creation of column defaults during creation of tables in the script. |
SQLDMOCreationScript_DRI_/ForeignKeys |
512 |
Includes creation of foreign keys during creation of tables in the script. |
SQLDMOCreationScript_DRI_/PrimaryKey |
128 |
Includes definition of primary keys on tables in the script. |
SQLDMOCreationScript_DRI_/UniqueKeys |
16384 |
Includes creation of unique keys during creation of tables in the script. |
SQLDMOCreationScript_/ExtendedProperties |
8192 |
Replicates extended properties. |
SQLDMOCreationScript_/NonClusteredIndexes |
64 |
Includes nonclustered index creation on tables in the script. |
SQLDMOCreationScript_/PKUKAsConstraints |
32768 |
Includes creation of primary keys and unique keys during creation of tables as constraints instead of as indexes in the script. |
SQLDMOCreationScript_/PrimaryObject |
1 |
Includes object creation in the script. |
SQLDMOCreationScript_/UDDTsToBaseTypes |
32 |
Converts all user-defined data types to their Microsoft SQL Server base types when defining columns in table creation in the script. |
SQLDMOCreationScript_UserTriggers |
256 |
Includes creation of triggers during creation of tables in the script. |