SQL Server
United States (English) Sign in
Home 2012 2008 R2 2008 Previous Versions Library Forums
TechNet Library
SQL Server
SQL Server 2005
Product Documentation
SQL Server 2005 Documentation
SQL Server 2005 Books Online
SQL Server Programming Reference
Database Engine Administration Programming
SQL-DMO
SQL-DMO Reference
Methods (SQL-DMO)
E (SQL-DMO Methods)
EnableAgentOffload Method
EnableFullTextCatalogs Method
EnableMergeSubscription Method
EnableTransSubscription Method
EnumAccountInfo Method
EnumAgentErrorRecords Method
EnumAgentParameters Method
EnumAgentProfiles Method
EnumAlerts Method
EnumAllSubscriptions Method
EnumAllSubsetFilters Method
EnumAlternatePublishers Method
EnumAvailableMedia Method
EnumCandidateKeys Method
EnumCollations Method
EnumColumns Method
EnumConflictTables Method
EnumCustomResolvers Method
EnumDatabaseMappings Method
EnumDatabaseRoleMember Method
EnumDataSourceNames Method
EnumDependencies Method
EnumDirectories Method
EnumDistributionAgentSessionDetails Method
EnumDistributionAgentSessionDetails2 Method
EnumDistributionAgentSessions Method
EnumDistributionAgentSessions2 Method
EnumDistributionAgentViews Method
EnumDistributionAgentViews2 Method
EnumErrorLogs Method
EnumFileGroups Method
EnumFiles Method (Database)
EnumFiles Method (FileGroup)
EnumFixedDatabaseRolePermission Method
EnumFullTextLanguages Method
EnumGeneratedSubsetFilters Method
EnumHistory Method
EnumIdentityRangeInfo Method
EnumInitialAccesses Method
EnumJobHistory Method
EnumJobInfo Method
EnumJobNotifications Method
EnumJobs Method
EnumLastStatisticsUpdates Method
EnumLocks Method
EnumLoginMappings Method
EnumLogReaderAgentSessionDetails Method
EnumLogReaderAgentSessionDetails2 Method
EnumLogReaderAgentSessions Method
EnumLogReaderAgentSessions2 Method
EnumLogReaderAgentView Method
EnumLogReaderAgentViews Method
EnumMatchingSPs Method
EnumMergeAgentSessionDetails Method
EnumMergeAgentSessionDetails2 Method
EnumMergeAgentSessions Method
EnumMergeAgentSessions2 Method
EnumMergeAgentViews Method
EnumMergeAgentViews2 Method
EnumMiscellaneousAgentViews Method
EnumNotifications Method
EnumNTDomainGroups Method
EnumNTGroups Method
EnumObjects Method
EnumOutputs Method
EnumParameters Method
EnumProcesses Method
EnumPublicationAccesses Method
EnumPublicationArticles Method
EnumPublicationReferences Method
EnumPublications Method
EnumPublications2 Method
EnumQueueReaderAgentSessionDetails Method
EnumQueueReaderAgentSessions Method
EnumQueueReaderAgentView Method
EnumQueueReaderAgentViews Method
EnumReferencedKeys Method
EnumReferencedTables Method
EnumReferencingKeys Method
EnumReferencingTables Method
EnumServerAttributes Method
EnumServerRoleMember Method
EnumServerRolePermission Method
EnumSnapshotAgentSessionDetails Method
EnumSnapshotAgentSessionDetails2 Method
EnumSnapshotAgentSessions Method
EnumSnapshotAgentSessions2 Method
EnumSnapshotAgentView Method
EnumSnapshotAgentViews Method
EnumStatistics Method
EnumSubscriptions Method
EnumSubscriptionViews Method
EnumSubscriptionViews2 Method
EnumSubSystems Method
EnumTables Method
EnumTargetServers Method
EnumThirdPartyPublications Method
EnumThirdPartyPublications2 Method
EnumThirdPartyVendorNames Method
EnumUsers Method
EnumVersionInfo Method
ExecuteImmediate Method (Database, SQLServer)
ExecuteImmediate Method (LinkedServer, RemoteServer)
ExecuteWithResults Method
ExecuteWithResultsAndMessages Method
ExecuteWithResultsAndMessages2 Method
ExportData Method
Expand Minimize
This topic has not yet been rated - Rate this topic

EnumCandidateKeys Method

SQL Server 2005

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 EnumCandidateKeys method returns a QueryResults object that enumerates the user tables of a Microsoft SQL Server database and the constraints on those tables that could define primary keys.

Copy 

object
.EnumCandidateKeys( )
as 
QueryResults
object

Expression that evaluates to an object in the Applies To list.

Copy 
HRESULT EnumCandidateKeys(
LPSQLDMOQUERYRESULTS* ppResults);

A QueryResults object that contains 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.

Did you find this helpful?
(1500 characters remaining)

Community Additions

ADD
© 2013 Microsoft
|
Site Feedback
© 2013 Microsoft. All rights reserved.