ODBC_SQLPrimaryKeys

4D - Documentation   Français   English   German   4D ODBC PRO, Command Theme List   4D ODBC PRO, Command Alphabetical List   Back   Previous   Next

version 2004


ODBC_SQLPrimaryKeys (stmtID; catalogName; schemaName; tableName) Longint

ParameterTypeDescription
stmtIDLongintStatement ID
catalogNameStringCatalog name
schemaNameStringString search pattern for schema names
tableNameStringString search pattern for table names
Function resultLongintReturns the result of the MS ODBC API function
SQLPrimaryKeys

Description

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 at http://msdn.microsoft.com/library/en-us/odbc/htm/odbcsqlprimarykeys.asp.

Function Results

SQL_SUCCESS, SQL_SUCCESS_WITH_INFO, SQL_STILL_EXECUTING, SQL_ERROR, or SQL_INVALID_HANDLE.

See Also

ODBC_SQLForeignKeys.


4D - Documentation   Français   English   German   4D ODBC PRO, Command Theme List   4D ODBC PRO, Command Alphabetical List   Back   Previous   Next