odbc_tables

(PHP 4, PHP 5, PHP 7)

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

说明

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

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 table_type are available:

  • 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.)
  • 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.)
  • 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.)

参数

connection_id

ODBC 连接标识符，详见 odbc_connect()。

qualifier

The qualifier.

owner

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

name

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

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 support a specified table type, odbc_tables() does not return any results for that type.

返回值

Returns an ODBC result identifier containing the information 或者在失败时返回 FALSE.

The result set has the following columns:

  • TABLE_QUALIFIER
  • TABLE_OWNER
  • TABLE_NAME
  • TABLE_TYPE
  • REMARKS

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

参见

相关文章
php mailparse 函数 streams data from source file pointer apply encoding and write to destfpphp odbc 函数 handling of binary column dataphp odbc 函数 lists columns and associated privileges for the given tablephp odbc 函数 lists the column names in specified tablesphp odbc 函数 get the columnnamephp odbc 函数 retrieves a list of foreign keysphp odbc 函数 retrieves information about data types supported by the data sourcephp odbc 函数 gets the primary keys for a tablephp odbc 函数 get the list of procedures stored in a specific data sourcephp odbc 函数 print result as html tablephp odbc 函数 get result dataphp odbc 函数 retrieve statistics about a tablephp odbc 函数 lists tables and the privileges associated with each tablephp odbc 函数 get the list of table names stored in a specific data sourcephp openal 函数 load a buffer with dataphp openal 函数 pause the sourcephp radius 函数 attaches a vendor specific ip address attributephp wincache 函数 retrieves information about data stored in the user cachephp hyperwave api 函数 returns a list of all source anchorsphp sdo das relational 函数 executes an sql query passed as a prepared statement with a list of values to substitute for placeholders and return the results as a normalised data graph
关注编程学问公众号