odbc_primarykeys

PHP 4, PHP 5, PHP 7, PHP 8
odbc_primarykeys - Gets the primary keys for a table
Manual
Code Examples

odbc_primarykeys( resource$odbc, string|null$catalog, string$schema, string$table ): resource|false

Returns a result identifier that can be used to fetch the column names that comprise the primary key for a table.

Parameters

odbc

The ODBC connection identifier, see odbc_connect for details.

catalog

The catalog ('qualifier' in ODBC 2 parlance).

schema

The schema ('owner' in ODBC 2 parlance).

table

Return Values

Returns an ODBC result identifier or false on failure.

The result set has the following columns:

TABLE_CAT

TABLE_SCHEM

TABLE_NAME

COLUMN_NAME

KEY_SEQ

PK_NAME

Drivers can report additional columns.

The result set is ordered by TABLE_CAT, TABLE_SCHEM, TABLE_NAME and KEY_SEQ.

Related Functions

Example of odbc_primarykeys

Show all examples for odbc_primarykeys

PHP Version: