SQL-DMO
Replication Object Creation Script Constants (SQLDMO_CREATIONSCRIPT_TYPE)
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_Collation | 4096 | Replicate column-level collation |
| SQLDMOCreationScript_CustomProcs | 2 | Generates custom stored procedures for the article if defined (transactional replication only) |
| SQLDMOCreationScript_DisableScripting | 0 | Do not script |
| SQLDMOCreationScript_DRI_Checks | 1024 | Include creation of check constraints during creation of tables in the script |
| SQLDMOCreationScript_DRI_Defaults | 2048 | Include creation of column defaults during creation of tables in the script |
| SQLDMOCreationScript_DRI_ForeignKeys | 512 | Include creation of foreign keys during creation of tables in the script |
| SQLDMOCreationScript_DRI_PrimaryKey | 128 | Include definition of primary keys on tables in the script |
| SQLDMOCreationScript_DRI_UniqueKeys | 16384 | Include creation of unique key during creation of tables in the script |
| SQLDMOCreationScript_ExtendedProperties | 8192 | Replicate extended properties |
| SQLDMOCreationScript_NonClusteredIndexes | 64 | Include nonclustered index creation on tables in the script |
| SQLDMOCreationScript_PKUKAsConstraints | 32768 | Include creation of primary key and unique key during creation of tables as constraints instead of as indexes 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 |
| SQLDMOCreationScript_UserTriggers | 256 | Include creation of trigger during creation of tables in the script |