Replication Article Pre-Creation Constants (SQLDMO_PREARTICLE_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 article pre-creation constants specify actions performed at a Subscriber prior to article synchronization.

Constant	Value	Description
SQLDMOPreArt_DeleteRows	2	Performs a logged delete prior to synchronization.
SQLDMOPreArt_DropTable	1	Drops and re-creates the table to synchronize.
SQLDMOPreArt_Max	3	SQLDMOPreArt_TruncateTable.
SQLDMOPreArt_Min	0	SQLDMOPreArt_None.
SQLDMOPreArt_None	0	Does nothing prior to synchronization.
SQLDMOPreArt_TruncateTable	3	Performs a bulk-logged delete prior to synchronization.