odbc_statistics

    (PHP 4, PHP 5, PHP 7, PHP 8)

    odbc_statistics — Retrieve statistics about a table

    Descrição

    odbc_statistics(
        resource$odbc,
        ?string$catalog,
        string$schema,
        string$table,
        int$unique,
        int$accuracy
    ): resource|false

    Get statistics about a table and its indexes.

    Parâmetros

    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.

    Valor Retornado

    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
    Drivers podem listar colunas adicionais.

    The result set is ordered by NON_UNIQUE, TYPE, INDEX_QUALIFIER, INDEX_NAME and ORDINAL_POSITION.

    Exemplos

    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] => )

    Veja Também

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