Php/docs/function.odbc-statistics
odbc_statistics
(PHP 4, PHP 5, PHP 7)
odbc_statistics — Retrieve statistics about a table
说明
odbc_statistics
( resource $connection_id
, string $catalog
, string $schema
, string $table_name
, int $unique
, int $accuracy
) : resource|false
Get statistics about a table and its indexes.
参数
connection_id
- ODBC 连接标识符,详见 odbc_connect()。
catalog
- The catalog ('qualifier' in ODBC 2 parlance).
schema
- The schema ('owner' in ODBC 2 parlance).
table_name
- The table name.
unique
- The type of the index. One of
SQL_INDEX_UNIQUE
orSQL_INDEX_ALL
. accuracy
- One of
SQL_ENSURE
orSQL_QUICK
. The latter requests that the driver retrieve theCARDINALITY
andPAGES
only if they are readily available from the server.
返回值
Returns an ODBC result identifier 或者在失败时返回 false
.
The result set has the following columns:
TABLE_CAT
TABLE_SCHEM
TABLE_NAME
NON_UNIQUE
INDEX_QUALIFIER
INDEX_NAME
TYPE
ORDINAL_POSITION
COLUMN_NAME
ASC_OR_DESC
CARDINALITY
PAGES
FILTER_CONDITION
Drivers can report additional columns.
The result set is ordered by NON_UNIQUE
, TYPE
, INDEX_QUALIFIER
,
INDEX_NAME
and ORDINAL_POSITION
.
范例
Example #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] => )