SQLPrimaryKeys

This function returns a list of column names that comprise the primary key for a table

Syntax :

RETCODE SQLPrimaryKeys (hstmt, catalogName, lenCatalogName, schemaName, lenschemaname, tableName);

Arguments :

The arguments for SQLPrimaryKeys are listed in below table.

Type	Name	Description
SQLHSTMT	hstmt	Statement handle.
SQLCHAR*	catalogName	Catalog qualifier of a 3 part table name. This must be a NULL pointer or a zero length string.
SQLSMALLINT	LenCataloName	Length of catalogName. This must be set to 0.
SQLCHAR*	SchemaName	Buffer that might contain a pattern-value to qualify the result set by schema name.
SQLSMALLINT	lenschemaname	Length of SchemaName
SQLCHAR*	tableName	Buffer that might contain a pattern-value to qualify the result set by table name.
SQLSMALLINT	lentableName	Length of tableName

Page last modified on September 26, 2009, at 01:52 AM