odbc_statistics
(PHP 4, PHP 5, PHP 7, PHP 8)
odbc_statistics — Retrieve statistics about a table
說明
odbc_statistics(
resource
?string
string
string
int
int
): resource|false
resource
$odbc,?string
$catalog,string
$schema,string
$table,int
$unique,int
$accuracy): resource|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_UNIQUEorSQL_INDEX_ALL.-
accuracy One of
SQL_ENSUREorSQL_QUICK. The latter requests that the driver retrieve theCARDINALITYandPAGESonly if they are readily available from the server.
返回值
Returns an ODBC result identifier 或者在失敗時返回 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
}
?> 以上例程的輸出類似於：
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] =>
)
參見
- odbc_tables() - Get the list of table names stored in a specific data source