getPrimaryKeys( catalog, schema, table )

Previous Next

Gets a description of a table's primary key columns. They are ordered by COLUMN_NAME.

Each primary key column description has the following columns:

TABLE_CAT

String

table catalog (may be null)

TABLE_SCHEM

String

table schema (may be null)

TABLE_NAME

String

table name

COLUMN_NAME

String

column name

KEY_SEQ

Short

sequence number within primary key

PK_NAME

String

primary key name (may be null)

Syntax

getPrimaryKeys( string catalog, string schema, string table )

Parameters

catalog

A catalog name

schema

A schema name

table

A table name

If catalog is "" (the empty string), only procedures without a catalog are returned.

If catalog is the null value, catalog names are not part of the selection criteria.

If schema is "" (the empty string), only procedures without a schema are returned.