sys.sp_pkeys

Description

Analytics Platform System (PDW) SQL database in Microsoft Fabric Returns primary key information for a single table in the current environment. Syntax for SQL Server, Azure SQL Database, Azure Synapse Analytics, Analytics Platform System Specifies the table for which to return information. Wildcard pattern matching isn’t supported. Specifies the table owner of the specified table.

Syntax

sp_pkeys
[ @table_name = ]
N
'table_name'
[ , [ @table_owner = ]
N
'table_owner'
]
[ , [ @table_qualifier = ]
N
'table_qualifier'
]
[ ; ]