Snapshot Replication

A subscriber table that is populated using snapshot replication does not require a primary key. Incremental updates are not used to propagate changes to data in the table, so it is not necessary to uniquely identify each row.

To enable snapshot replication to tables without primary keys, run the sp_addarticle stored procedure to create the articles; the table names will not appear in the Article Table list if they do not have a declared primary key.