Returns primary key information for a single table.
Primary
keys must be declared through the ANSI integrity constraint mechanism.
Syntax
sp_pkeys table_name [, table_owner]
[, table_qualifier]
Parameters
- table_name – is the name of the table. Wildcard-character search
patterns are not supported.
- table_owner – is the owner of the table. Wildcard-character search
patterns are not supported.
- table_qualifier – is ignored. Leave blank or set to NULL.
Usage
This procedure corresponds to the ODBC function SQLPrimaryKeys.