(PHP 4 >= 4.0.0)
odbc_columns -- Lists the column names in specified tables. Returns a result identifier
containing the information.
Description
int odbc_columns (int connection_id [, string qualifier [, string
owner [, string table_name [, string column_name]]]])
Lists all columns in the requested range. Returns an ODBC result identifier or
FALSE on failure.
The result set has the following columns:
-
TABLE_QUALIFIER
-
TABLE_OWNER
-
TABLE_NAME
-
COLUMN_NAME
-
DATA_TYPE
-
TYPE_NAME
-
PRECISION
-
LENGTH
-
SCALE
-
RADIX
-
NULLABLE
-
REMARKS
The result set is ordered by TABLE_QUALIFIER, TABLE_OWNER and TABLE_NAME.
The owner, table_name and column_name
arguments accept search patterns ('%' to match zero or more characters and '_' to match a single
character).
See also odbc_columnprivileges()
to retrieve associated privileges.
|