odbc_specialcolumns
(PHP 4, PHP 5, PHP 7)
odbc_specialcolumns — Retrieves special columns
说明
odbc_specialcolumns (
resource
$connection_id
,
int $type
,
string $qualifier
,
string $table
,
int $scope
,
int $nullable
) :
resource
Retrieves either the optimal set of columns that uniquely identifies a row in the table, or columns that are automatically updated when any value in the row is updated by a transaction.
参数
-
connection_id
-
ODBC 连接标识符,详见 odbc_connect()。
-
type
-
When the type argument is
SQL_BEST_ROWID
, odbc_specialcolumns() returns the column or columns that uniquely identify each row in the table. When the type argument isSQL_ROWVER
, odbc_specialcolumns() returns the column or columns in the specified table, if any, that are automatically updated by the data source when any value in the row is updated by any transaction. -
qualifier
-
The qualifier.
-
table
-
The table.
-
scope
-
The scope, which orders the result set.
-
nullable
-
The nullable option.
返回值
Returns an ODBC result identifier or FALSE
on failure.
The result set has the following columns:
- SCOPE
- COLUMN_NAME
- DATA_TYPE
- TYPE_NAME
- PRECISION
- LENGTH
- SCALE
- PSEUDO_COLUMN