Php/docs/function.odbc-statistics

来自菜鸟教程
跳转至:导航、​搜索

odbc_statistics

(PHP 4, PHP 5, PHP 7)

odbc_statisticsRetrieve 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 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 或者在失败时返回 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] =>
)

参见

  • odbc_tables() - Get the list of table names stored in a specific data source