The SQLPRIMARYKEYS view contains one row for every primary constraint key
on a table. The following table describes the columns in the
view:
Table 139. SQLPRIMARYKEYS view
Column Name | Data Type | Description |
---|---|---|
TABLE_CAT | VARCHAR(128) | Relational database name |
TABLE_SCHEM | VARCHAR(128) | Name of the schema containing the table with the primary key. |
TABLE_NAME | VARCHAR(128) | Name of the table with the primary key. |
COLUMN_NAME | VARCHAR(128) | Name of a primary key column. |
KEY_SEQ | SMALLINT | The position of the column within the key. |
PK_NAME | VARCHAR(128) | Name of the primary key constraint. |
(C) Copyright IBM Corporation 1992, 2005. All Rights Reserved.