PHP is developed and maintained by a global community of contributors.
The PHP Foundation helps fund this work. If PHP is part of your business or projects, consider sponsoring the Foundation.
(PHP 4, PHP 5, PHP 7, PHP 8)
odbc_primarykeys — Gets the primary keys for a table
$odbc,$catalog,$schema,$tableReturns a result object that can be used to fetch the column names that comprise the primary key for a table.
odbcODBC 连接对象，详见 odbc_connect()。
catalogThe catalog ('qualifier' in ODBC 2 parlance).
schemaThe schema ('owner' in ODBC 2 parlance).
table
返回 ODBC 结果对象 或者在失败时返回 false。
The result set has the following columns:
TABLE_CAT
TABLE_SCHEM
TABLE_NAME
COLUMN_NAME
KEY_SEQ
PK_NAME
The result set is ordered by TABLE_CAT, TABLE_SCHEM,
TABLE_NAME and KEY_SEQ.
| 版本 | 说明 |
|---|---|
| 8.4.0 |
odbc 现在需要 Odbc\Connection
实例；之前需要 resource。
|
| 8.4.0 | 此函数现在返回 Odbc\Result 实例；之前返回 resource。 |
示例 #1 List primary Keys of a Column
<?php
$conn = odbc_connect($dsn, $user, $pass);
$primarykeys = odbc_primarykeys($conn, 'TutorialDB', 'dbo', 'TEST');
while (($row = odbc_fetch_array($primarykeys))) {
print_r($row);
break; // further rows omitted for brevity
}
?>以上示例的输出类似于：
Array
(
[TABLE_CAT] => TutorialDB
[TABLE_SCHEM] => dbo
[TABLE_NAME] => TEST
[COLUMN_NAME] => id
[KEY_SEQ] => 1
[PK_NAME] => PK__TEST__3213E83FE141F843
)
