array ( 0 => 'index.php', 1 => 'PHP Manual', ), 'head' => array ( 0 => 'UTF-8', 1 => 'pt_BR', ), 'this' => array ( 0 => 'function.odbc-statistics.php', 1 => 'odbc_statistics', ), 'up' => array ( 0 => 'ref.uodbc.php', 1 => 'ODBC Funções', ), 'prev' => array ( 0 => 'function.odbc-specialcolumns.php', 1 => 'odbc_specialcolumns', ), 'next' => array ( 0 => 'function.odbc-tableprivileges.php', 1 => 'odbc_tableprivileges', ), 'alternatives' => array ( ), 'source' => array ( 'lang' => 'en', 'path' => 'reference/uodbc/functions/odbc-statistics.xml', ), ); $setup["toc"] = $TOC; $setup["toc_deprecated"] = $TOC_DEPRECATED; $setup["parents"] = $PARENTS; manual_setup($setup); ?>
(PHP 4, PHP 5, PHP 7, PHP 8)
odbc_statistics — Retrieve statistics about a table
$odbc
,$catalog
,$schema
,$table
,$unique
,$accuracy
Get statistics about a table and its indexes.
odbc
O identificador da conexão ODBC. Consulte odbc_connect() para obter detalhes.
catalog
O catálogo ('qualifier' na linguagem ODBC 2).
schema
O esquema ('owner' na linguagem ODBC 2).
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.
Returns an ODBC result identifier ou false
em caso de falha.
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
The result set is ordered by NON_UNIQUE
, TYPE
, INDEX_QUALIFIER
,
INDEX_NAME
and ORDINAL_POSITION
.
Exemplo #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
}
?>
O exemplo acima produzirá algo semelhante a:
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] => )