ODBC_FOREIGNKEYS(3) 1 ODBC_FOREIGNKEYS(3)
odbc_foreignkeys - Retrieves a list of foreign keys
SYNOPSIS
resource odbc_foreignkeys (resource $connection_id, string $pk_qualifier, string $pk_owner, string $pk_table, string $fk_qualifier,
string $fk_owner, string $fk_table)
DESCRIPTION
Retrieves a list of foreign keys in the specified table or a list of foreign keys in other tables that refer to the primary key in the
specified table
PARAMETERS
o $connection_id
-The ODBC connection identifier, see odbc_connect(3) for details.
o $pk_qualifier
- The primary key qualifier.
o $pk_owner
- The primary key owner.
o $pk_table
- The primary key table.
o $fk_qualifier
- The foreign key qualifier.
o $fk_owner
- The foreign key owner.
o $fk_table
- The foreign key table.
RETURN VALUES
Returns an ODBC result identifier or FALSE on failure.
The result set has the following columns:
oPKTABLE_QUALIFIER
oPKTABLE_OWNER
oPKTABLE_NAME
oPKCOLUMN_NAME
oFKTABLE_QUALIFIER
oFKTABLE_OWNER
oFKTABLE_NAME
oFKCOLUMN_NAME
oKEY_SEQ
oUPDATE_RULE
oDELETE_RULE
oFK_NAME
oPK_NAME
If $pk_table contains a table name, odbc_foreignkeys(3) returns a result set containing the primary key of the specified table and all of
the foreign keys that refer to it.
If $fk_table contains a table name, odbc_foreignkeys(3) returns a result set containing all of the foreign keys in the specified table and
the primary keys (in other tables) to which they refer.
If both $pk_table and $fk_table contain table names, odbc_foreignkeys(3) returns the foreign keys in the table specified in $fk_table that
refer to the primary key of the table specified in $pk_table. This should be one key at most.
PHP Documentation Group ODBC_FOREIGNKEYS(3)