ReplicationTable.HasPrimaryKey 屬性
Gets a value that indicates whether or not the table has a primary key.
命名空間： Microsoft.SqlServer.Replication
組件： Microsoft.SqlServer.Rmo (在 Microsoft.SqlServer.Rmo.dll 中)
語法
'宣告
Public ReadOnly Property HasPrimaryKey As Boolean
Get
'用途
Dim instance As ReplicationTable
Dim value As Boolean
value = instance.HasPrimaryKey
public bool HasPrimaryKey { get; }
public:
property bool HasPrimaryKey {
bool get ();
}
member HasPrimaryKey : bool
function get HasPrimaryKey () : boolean
屬性值
型別：System.Boolean
true if the table has primary key; false if the table has no primary key.
備註
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.