Propriedade do RDL ReplicationTable.HasPrimaryKey

Gets a value that indicates whether or not the table has a primary key.

Namespace:  Microsoft.SqlServer.Replication
Assembly:  Microsoft.SqlServer.Rmo (em Microsoft.SqlServer.Rmo.dll)

Sintaxe

'Declaração
Public ReadOnly Property HasPrimaryKey As Boolean 
    Get
'Uso
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

Valor da propriedade

Tipo: System.Boolean
true if the table has primary key; false if the table has no primary key.

Comentários

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.

Consulte também

Referência

ReplicationTable Classe

Namespace Microsoft.SqlServer.Replication