mixed metaForeignKeys( string $tableName, optional string $owner='', optional bool $upperCase=false, optional bool $associative=false )
The function metaForeignKeys()
returns an array of the foreign keys associated with a specific table. If there are no foreign keys then the function returns false.
If specified, only returns foreign keys associated with a table owned by that name. Some drivers discard this parameter
if specified, only matches the table with the uppercase name. This parameter is discarded by some drivers
If specified, returns the result in associative mode. If ADODB_FETCH_MODE is already associative, then this parameter is discarded. Some drivers ignore this parameter.
The method returns an array of data:
associative
, or a numeric key with value being the same data represented as local column
+ '=' + foreign column
./* * Connection to MySql Employees Sample database */ $db->setFetchMode(ADODB_FETCH_NUM); $p = $db->metaForeignKeys('dept_emp'); print_r($p); /* * prints Array ( [employees] => Array ( [0] => emp_no=emp_no ) [departments] => Array ( [0] => dept_no=dept_no ) ) */
$db->setFetchMode(ADODB_FETCH_ASSOC); $p = $db->metaForeignKeys('dept_emp'); print_r($p); /* * prints Array ( [employees] => Array ( [emp_no]=>emp_no ) [departments] => Array ( [dept_no]=>dept_no ) ) */