db2_statistics
Opis
resource db2_statistics ( resource connection, string qualifier, string schema, string table-name, bool unique )Returns a result set listing the index and statistics for a table.
Parametry
connection
A valid connection to an IBM DB2, Cloudscape, or Apache Derby database.
qualifier
A qualifier for DB2 databases running on OS/390 or z/OS servers. For other databases, pass NULL or an empty string.
schema
The schema that contains the targeted table. If this parameter is NULL, the statistics and indexes are returned for the schema of the current user.
table_name
The name of the table.
unique
An integer value representing the type of index information to return.
0
Return only the information for unique indexes on the table.
1
Return the information for all indexes on the table.
Zwracane wartości
Returns a statement resource with a result set containing rows describing the statistics and indexes for the base tables matching the specified parameters. The rows are composed of the following columns:
Patrz także
db2_column_privileges() |
db2_columns() |
db2_foreign_keys() |
db2_primary_keys() |
db2_procedure_columns() |
db2_procedures() |
db2_special_columns() |
db2_table_privileges() |
db2_tables() |
Poprzedni | Spis treści | Następny |
db2_special_columns | Początek rozdziału |