4D v14.1

ODBC_SQLPrimaryKeys

Home

 
4D v14.1
ODBC_SQLPrimaryKeys

ODBC_SQLPrimaryKeys 


 

ODBC_SQLPrimaryKeys ( stmtID ; catalogName ; schemaName ; tableName ) -> Function result 
Parameter Type   Description
stmtID  Longint in Statement ID
catalogName  String in Catalog name
schemaName  String in String search pattern for schema names
tableName  String in String search pattern for table names
Function result  Longint in Returns the result of the MS ODBC API function SQLPrimaryKeys

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.

SQL_SUCCESS, SQL_SUCCESS_WITH_INFO, SQL_STILL_EXECUTING, SQL_ERROR, or SQL_INVALID_HANDLE.

 
PROPERTIES 

Product: 4D
Theme: ODBC_Catalog functions
Number: 16943

 
HISTORY 

Created: 4D ODBC Pro 2004

 
SEE ALSO 

ODBC_SQLForeignKeys

 
ARTICLE USAGE

4D ODBC Pro ( 4D ODBC Pro v11.4)
4D ODBC Pro ( 4D ODBC Pro v12)
4D ODBC Pro ( 4D v13)
4D ODBC Pro ( 4D v14 R3)
4D ODBC Pro ( 4D v14.1)
4D ODBC Pro ( 4D v14 R2)
4D ODBC Pro ( 4D v14 R4)