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)