odbc_tables(3) [php man page]

ODBC_TABLES(3)								 1							    ODBC_TABLES(3)

odbc_tables - Get the list of table names stored in a specific data source

SYNOPSIS

       resource odbc_tables (resource  $connection_id, [string	$qualifier], [string  $owner], [string	$name], [string  $types])

DESCRIPTION

	Lists all tables in the requested range.

	To support enumeration of qualifiers, owners, and table types, the following special semantics for the $qualifier, $owner, $name, and $ta-
       ble_type are available:

	      o If $qualifier is a single percent character (%) and $owner and $name are empty strings, then the result set  contains  a  list	of
	      valid qualifiers for the data source. (All columns except the TABLE_QUALIFIER column contain NULLs.)

	      o  If  $owner  is  a single percent character (%) and $qualifier and $name are empty strings, then the result set contains a list of
	      valid owners for the data source. (All columns except the TABLE_OWNER column contain NULLs.)

	      o If $table_type is a single percent character (%) and $qualifier, $owner and $name are empty strings, then the result set  contains
	      a list of valid table types for the data source. (All columns except the TABLE_TYPE column contain NULLs.)

PARAMETERS

	      o $connection_id
		-The ODBC connection identifier, see odbc_connect(3) for details.

	      o $qualifier
		- The qualifier.

	      o $owner
		- The owner. Accepts search patterns ('%' to match zero or more characters and '_' to match a single character).

	      o $name
		- The name. Accepts search patterns ('%' to match zero or more characters and '_' to match a single character).

	      o $types
		-  If  $table_type  is not an empty string, it must contain a list of comma-separated values for the types of interest; each value
		may be enclosed in single quotes (') or unquoted. For example, "'TABLE','VIEW'" or "TABLE, VIEW". If the data source does not sup-
		port a specified table type, odbc_tables(3) does not return any results for that type.

RETURN VALUES

	Returns an ODBC result identifier containing the information or FALSE on failure.

	The result set has the following columns:

	      oTABLE_QUALIFIER

	      oTABLE_OWNER

	      oTABLE_NAME

	      oTABLE_TYPE

	      oREMARKS

	The result set is ordered by TABLE_TYPE, TABLE_QUALIFIER, TABLE_OWNER and TABLE_NAME.

SEE ALSO

       odbc_tableprivileges(3).

PHP Documentation Group 													    ODBC_TABLES(3)

DB2_COLUMN_PRIVILEGES(3)						 1						  DB2_COLUMN_PRIVILEGES(3)

db2_column_privileges - Returns a result set listing the columns and associated privileges for a table

SYNOPSIS

       resource  db2_column_privileges	(resource   $connection, [string  $qualifier], [string	$schema], [string  $table-name], [string  $column-
       name])

DESCRIPTION

	Returns a result set listing the columns and associated privileges for a table.

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. To match all schemas, pass NULL or an empty string.

	      o $table-name
		- The name of the table or view. To match all tables in the database, pass NULL or an empty string.

	      o $column-name
		- The name of the column. To match all columns in the table, pass NULL or an empty string.

RETURN VALUES

	Returns a statement resource with a result set containing rows describing the column privileges for columns matching the specified parame-
       ters. The rows are composed of the following columns:

       +-------------+---------------------------------------------------+
       |Column name  |							 |
       |	     |							 |
       |	     |			  Description			 |
       |	     |							 |
       +-------------+---------------------------------------------------+
       | TABLE_CAT   |							 |
       |	     |							 |
       |	     | Name  of  the  catalog. The value is NULL if this |
       |	     | table does not have catalogs.			 |
       |	     |							 |
       |TABLE_SCHEM  |							 |
       |	     |							 |
       |	     |		      Name of the schema.		 |
       |	     |							 |
       | TABLE_NAME  |							 |
       |	     |							 |
       |	     |		  Name of the table or view.		 |
       |	     |							 |
       |COLUMN_NAME  |							 |
       |	     |							 |
       |	     |		      Name of the column.		 |
       |	     |							 |
       |  GRANTOR    |							 |
       |	     |							 |
       |	     | Authorization ID of  the  user  who  granted  the |
       |	     | privilege.					 |
       |	     |							 |
       |  GRANTEE    |							 |
       |	     |							 |
       |	     | Authorization  ID  of the user to whom the privi- |
       |	     | lege was granted.				 |
       |	     |							 |
       | PRIVILEGE   |							 |
       |	     |							 |
       |	     |		 The privilege for the column.		 |
       |	     |							 |
       |IS_GRANTABLE |							 |
       |	     |							 |
       |	     | Whether the GRANTEE is permitted  to  grant  this |
       |	     | privilege to other users.			 |
       |	     |							 |
       +-------------+---------------------------------------------------+
SEE ALSO

       db2_columns(3),	db2_foreign_keys(3), db2_primary_keys(3), db2_procedure_columns(3), db2_procedures(3), db2_special_columns(3), db2_statis-
       tics(3), db2_table_privileges(3), db2_tables(3).

PHP Documentation Group 												  DB2_COLUMN_PRIVILEGES(3)