Returns primary and foreign key information for the specified
table or tables.
Foreign keys must be declared through the ANSI
integrity constraint mechanism.
Syntax
sp_fkeys pktable_name [, pktable_owner]
[, pktable_qualifier] [, fktable_name]
[, fktable_owner] [, fktable_qualifier]
Parameters
- pktable_name – is the name of the table
containing the primary key. Wildcard-character search patterns are not supported. You must
specify this parameter, the fktable_name parameter, or both.
- pktable_owner – is the owner of the table containing the primary
key. Wildcard-character search patterns are not supported.
- pktable_qualifier – is ignored. Leave blank or set to NULL.
- fktable_name – is the name of the table
containing the foreign key. Wildcard-character search patterns are not supported. You must
specify this parameter, the pktable_name parameter, or both.
- fktable_owner – is the owner of the table containing the foreign
key. Wildcard-character search patterns are not supported.
- fktable_qualifier – is ignored. Leave blank or set to NULL.
Usage
This procedure corresponds to the ODBC function SQLForeignKeys.