Share via


HasPrimaryKey Property

This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.

The HasPrimaryKey property returns TRUE if the referenced table has a PRIMARY KEY constraint defined on a column.

Syntax

object.HasPrimaryKey

Parts

  • object
    An expression that evaluates to an object in the Applies To list

Data Type

Boolean

Modifiable

Read-only

Prototype (C/C++)

HRESULT GetHasPrimaryKey(LPBOOL pRetVal);

Remarks

Transactional replication requires a primary key to identify rows. For an instance of Microsoft SQL Server, primary keys are implemented in PRIMARY KEY and UNIQUE key constraints.

If TRUE, the table contains a PRIMARY KEY constraint and can be published as an article in a transactional publication.

If FALSE, the table does not contain support for transactional replication and cannot be published as a transactional article.