# 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 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