sp_pkeys

Description

Returns primary key information for a single table. Primary keys must be declared through the ANSI integrity constraint mechanism.

Syntax

sp_pkeys table_name [, table_owner]
 [, table_qualifier]

Parameters

table_name

is the name of the table. Wildcard-character search patterns are not supported.

table_owner

is the owner of the table. Wildcard-character search patterns are not supported.

table_qualifier

is ignored. Leave blank or set to NULL.

Usage

This procedure corresponds to the ODBC function SQLPrimaryKeys.

Copyright © 2005. Sybase Inc. All rights reserved.

View this book as PDF