article Properties, Snapshot Tab
The following options are available on the Snapshot tab of the article Properties dialog box.
Options
Keep the existing table unchanged
Keep all the existing data and schema in the Subscriber table with the same name as the destination table.
DROP the existing table and re-create it
Delete the Subscriber table that has the same name as the destination table and create a new table locally that is identical to the table at the Publisher.
Delete data in the existing table that matches the row filter statement
Delete the data that matches the data to be replicated from the Publisher in the Subscriber table with the same name as the destination table. Data in the local table that does not match the data to be replicated remains unchanged in the local table.
Delete all data in the existing table
Delete all the data but keep the table schema in the Subscriber table with the same name as the destination table.
Include declared referential integrity
Copy all primary key constraints, reference constraints, and unique constraints to the destination table if they exist on the source table at the Publisher.
Clustered indexes
Copy clustered indexes to the destination table if they exist on the source table at the Publisher.
Nonclustered indexes
Copy nonclustered indexes to the destination table if they exist on the source table at the Publisher.
User triggers
Copy user triggers to the destination table if they exist on the source table at the Publisher.
Extended properties
Copy extended properties to the destination table if they exist on the source table at the Publisher.
Collation
Copy collation specifications to the destination database if they exist on the source database at the Publisher.
Convert user-defined to base data types
Convert the user-defined types to the original data types on which they were based if there are user-defined data types in the source table at the Publisher. Converting user-defined data types to base data types may alter the formatting and other characteristics of the data.