DB2 Universal Database for iSeries SQL Reference

SQLPRIMARYKEYS

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.


[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]