ODBC_COLUMNS(3) 1 ODBC_COLUMNS(3)
odbc_columns - Lists the column names in specified tables
SYNOPSIS
resource odbc_columns (resource $connection_id, [string $qualifier], [string $schema], [string $table_name], [string $column_name])
DESCRIPTION
Lists all columns in the requested range.
PARAMETERS
o $connection_id
-The ODBC connection identifier, see odbc_connect(3) for details.
o $qualifier
- The qualifier.
o $schema
- The owner.
o $table_name
- The table name.
o $column_name
- The column name.
The $schema, $table_name, and $column_name accept search patterns ('%' to match zero or more characters and '_' to match a single charac-
ter).
RETURN VALUES
Returns an ODBC result identifier or FALSE on failure.
The result set has the following columns:
oTABLE_QUALIFIER
oTABLE_SCHEM
oTABLE_NAME
oCOLUMN_NAME
oDATA_TYPE
oTYPE_NAME
oPRECISION
oLENGTH
oSCALE
oRADIX
oNULLABLE
oREMARKS
The result set is ordered by TABLE_QUALIFIER, TABLE_SCHEM and TABLE_NAME.
SEE ALSO
odbc_columnprivileges(3) to retrieve associated privileges.
PHP Documentation Group ODBC_COLUMNS(3)
