|
|
Tables for Ada 1.8 (Default branch)
03-30-2008
|
|
DB2_TABLES(3) 1 DB2_TABLES(3) db2_tables - Returns a result set listing the tables and associated metadata in a database SYNOPSIS
resource db2_tables (resource $connection, [string $qualifier], [string $schema], [string $table-name], [string $table-type]) DESCRIPTION
Returns a result set listing the tables and associated metadata in a database. PARAMETERS
o $connection - A valid connection to an IBM DB2, Cloudscape, or Apache Derby database. o $qualifier - A qualifier for DB2 databases running on OS/390 or z/OS servers. For other databases, pass NULL or an empty string. o $schema - The schema which contains the tables. This parameter accepts a search pattern containing _ and % as wildcards. o $table-name - The name of the table. This parameter accepts a search pattern containing _ and % as wildcards. o $table-type - A list of comma-delimited table type identifiers. To match all table types, pass NULL or an empty string. Valid table type iden- tifiers include: ALIAS, HIERARCHY TABLE, INOPERATIVE VIEW, NICKNAME, MATERIALIZED QUERY TABLE, SYSTEM TABLE, TABLE, TYPED TABLE, TYPED VIEW, and VIEW. RETURN VALUES
Returns a statement resource with a result set containing rows describing the tables that match the specified parameters. The rows are composed of the following columns: +------------+---------------------------------------------------+ |Column name | | | | | | | Description | | | | +------------+---------------------------------------------------+ | TABLE_CAT | | | | | | | The catalog that contains the table. The value is | | | NULL if this table does not have catalogs. | | | | |TABLE_SCHEM | | | | | | | Name of the schema that contains the table. | | | | |TABLE_NAME | | | | | | | Name of the table. | | | | |TABLE_TYPE | | | | | | | Table type identifier for the table. | | | | | REMARKS | | | | | | | Description of the table. | | | | +------------+---------------------------------------------------+ SEE ALSO
db2_column_privileges(3), db2_columns(3), db2_foreign_keys(3), db2_primary_keys(3), db2_procedure_columns(3), db2_procedures(3), db2_spe- cial_columns(3), db2_statistics(3), db2_table_privileges(3). PHP Documentation Group DB2_TABLES(3)