odbc_specialcolumns()

(PHP 4, PHP 5, PHP 7)

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 is SQL_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