September 2001
Intermediate to advanced
768 pages
32h 45m
English
int odbc_statistics(resource conn, string catalog, string owner, string table, int unique, int accuracy)
| conn | Connection ID |
| catalog | Database name |
| owner | Database owner |
| table | Table name |
| unique | Unique indexes |
| accuracy | Accuracy |
Returns information about tables and indexes.
Returns:
Result identifier; FALSE on error
Description:
This function simply returns a list of indexes from the specified table. Columns returned are TABLE_CAT, TABLE_SCHEM, TABLE_NAME, NON_UNIQUE, INDEX_QUALIFIER, INDEX_NAME, TYPE, ORDINAL_POSITION, COLUMN_NAME, ASC_OR_DESC, CARDINALITY, PAGES, SEQ_IN_INDEX, and FILTER_CONDITION. Results are sorted by NON_UNIQUE, TYPE, INDEX_NAME, and SEQ_IN_INDEX.
Version:
Existing since version 4.0
Example:
Read now
Unlock full access