php man page for db2_tables

Query: db2_tables

OS: php

Section: 3

Format: Original Unix Latex Style Formatted with HTML and a Horizontal Scroll Bar

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)
Related Man Pages
capture-schema(1m) - sunos
db2_primary_keys(3) - php
db2_statistics(3) - php
db2_special_columns(3) - php
odbc_tables(3) - php
Similar Topics in the Unix Linux Community
IBM DB2 Product Suite
Insert Command Creating Table Locking Problem
Dynamically checking rules in database tables using SQL
DB2 in awk
Matching tables