ReplicationTable.HasPrimaryKey Property
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
Gets a value that indicates whether or not the table has a primary key.
public:
property bool HasPrimaryKey { bool get(); };public bool HasPrimaryKey { get; }member this.HasPrimaryKey : boolPublic ReadOnly Property HasPrimaryKey As BooleanProperty Value
true if the table has primary key; false if the table has no primary key.
Remarks
Transactional replication requires a primary key to identify rows. If there is a primary key constraint on one of the columns, the table can be published as an article in a transactional publication as well as in a snapshot and merge publication. If there is no primary key constraint on the table, then it is not possible to publish this table in a transactional publication.
The HasPrimaryKey property can be retrieved by members of the sysadmin fixed server role at the Publisher or by members of the db_owner fixed database role on the publication database.