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 | Include clustered index creation on tables in the script |
| SQLDMOCreationScript_ CustomProcs |
2 | Generates custom stored procedures for the article if defined (transactional replication only) |
| SQLDMOCreationScript_ DisableScripting |
0 | Do not script |
| SQLDMOCreationScript_DRI_ PrimaryKey |
128 | Include definition of primary keys on tables in the script |
| SQLDMOCreationScript_ NonClusteredIndexes |
64 | Include nonclustered index creation on tables in the script |
| SQLDMOCreationScript_ PrimaryObject |
1 | Include object creation in the script |
| SQLDMOCreationScript_ UDDTsToBaseTypes |
32 | Convert all user-defined data types to their Microsoft® SQL Server™ base types when defining columns in table creation in the script |
CreationScriptOptions Property