(PHP 4, PHP 5, PHP 7, PHP 8)
odbc_statistics — Retrieve statistics about a table
$odbc,$catalog,$schema,$table,$unique,$accuracyGet statistics about a table and its indexes.
odbcODBC 連接標識符，詳見(jiàn) odbc_connect()。
catalogThe catalog ('qualifier' in ODBC 2 parlance).
schemaThe schema ('owner' in ODBC 2 parlance).
tableThe 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.
Returns an ODBC result identifier 或者在失敗時(shí)返回 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.
示例 #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
}
?>
以上例程的輸出類(lèi)似于：
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] =>
)