ODBC_SQLPrimaryKeys

Home

4D v16

ODBC_SQLPrimaryKeys


ODBC_SQLPrimaryKeys ( stmtID ; catalogName ; schemaName ; tableName ) -> Funktionsergebnis

Parameter	Typ	Beschreibung
stmtID	Lange Ganzzahl	Statement ID
catalogName	String	Catalog name
schemaName	String	String search pattern for schema names
tableName	String	String search pattern for table names
Funktionsergebnis	Lange Ganzzahl	Returns the result of the MS ODBC API function SQLPrimaryKeys

Beschreibung

The ODBC_SQLPrimaryKeys command returns column names that make up the primary key for a table. The driver returns the information as a result set. This command does not support returning primary keys from multiple tables in a single call.

stmtID is a valid statement ID returned by ODBC_SQLAllocStmt.

catalogName is the catalog name.

schemaName is the string search pattern for schema names.

tableName is the string search pattern for table names.

For more information, please see the SQLPrimaryKeys function in the MS ODBC API Reference at http://msdn.microsoft.com/en-us/library/ms711005(VS.85).aspx.

Function Results

SQL_SUCCESS, SQL_SUCCESS_WITH_INFO, SQL_STILL_EXECUTING, SQL_ERROR, or SQL_INVALID_HANDLE.

Siehe auch

ODBC_SQLForeignKeys