EnumCandidateKeys Method (SQL-DMO)

The EnumCandidateKeys method returns a QueryResults object enumerating the user tables of a Microsoft® SQL Server™ database and the constraints on those tables that could define primary keys.

Applies To

Database Object

Syntax

object.EnumCandidateKeys() as QueryResults

Part Description
object Expression that evaluates to an object in the Applies To list

Returns

A QueryResults object containing one result set defined by these columns.

Column Data type Description
candidate_table nvarchar(262) SQL Server table name
candidate_key nvarchar(129) Name of an existing UNIQUE or PRIMARY KEY constraint

Prototype (C/C++)

HRESULT EnumCandidateKeys(
LPSQLDMOQUERYRESULTS* ppResults);

  


(c) 1988-98 Microsoft Corporation. All Rights Reserved.