odbc_statistics
(PHP 4, PHP 5, PHP 7, PHP 8)
odbc_statistics — Retrieve statistics about a table
说明
Odbc\Connection
$odbc,?string
$catalog,string
$schema,string
$table,int
$unique,int
$accuracy): Odbc\Result|false
Get statistics about a table and its indexes.
参数
odbc
ODBC 连接对象,详见 odbc_connect()。
catalog
The catalog ('qualifier' in ODBC 2 parlance).
schema
The schema ('owner' in ODBC 2 parlance).
table
The table name.
unique
The type of the index.
One of SQL_INDEX_UNIQUE or SQL_INDEX_ALL.
accuracy
One of SQL_ENSURE or SQL_QUICK.
The latter requests that the driver retrieve the CARDINALITY and
PAGES only if they are readily available from the server.
返回值
返回 ODBC 结果对象 或者在失败时返回 false。
The result set has the following columns:
TABLE_CATTABLE_SCHEMTABLE_NAMENON_UNIQUEINDEX_QUALIFIERINDEX_NAMETYPEORDINAL_POSITIONCOLUMN_NAMEASC_OR_DESCCARDINALITYPAGESFILTER_CONDITION
The result set is ordered by NON_UNIQUE, TYPE, INDEX_QUALIFIER,
INDEX_NAME and ORDINAL_POSITION.
更新日志
| 版本 | 说明 |
|---|---|
| 8.4.0 |
odbc 现在需要 Odbc\Connection
实例;之前需要 resource。
|
| 8.4.0 | 此函数现在返回 Odbc\Result 实例;之前返回 resource。 |
示例
示例 #1 List Statistics of a Table
<?php
$conn = odbc_connect($dsn, $user, $pass);
$statistics = odbc_statistics($conn, 'TutorialDB', 'dbo', 'TEST', SQL_INDEX_UNIQUE, SQL_QUICK);
while (($row = odbc_fetch_array($statistics))) {
print_r($row);
break; // further rows omitted for brevity
}
?>以上示例的输出类似于:
Array
(
[TABLE_CAT] => TutorialDB
[TABLE_SCHEM] => dbo
[TABLE_NAME] => TEST
[NON_UNIQUE] =>
[INDEX_QUALIFIER] =>
[INDEX_NAME] =>
[TYPE] => 0
[ORDINAL_POSITION] =>
[COLUMN_NAME] =>
[ASC_OR_DESC] =>
[CARDINALITY] => 15
[PAGES] => 3
[FILTER_CONDITION] =>
)
来源:PHP Documentation Group · 作者与贡献记录 · CC BY 3.0。离线整理了版式、链接和媒体显示。
