Select Clause Formats: Primary Keys
SELECT
1,
TABLE_OWNER,
TABLE_NAME,
COLUMN_NAME,
KEY_SEQUENCE,
PK_NAME
FROM ...
WHERE ...
• TABLE_OWNER: owner of the primary key table
• TABLE_NAME: name of the primary key table
• COLUMN_NAME: name of the primary key column
• KEY_SEQUENCE: Number of the column in the key sequence (starts at 1)
• PK_NAME: Name of the primary key; “1” if this name is not supported by the DBMS.