odbc_specialcolumns
odbc_specialcolumns
(PHP 4, PHP 5, PHP 7)
odbc_specialcolumns — Retrieves special columns
Description
resource odbc_specialcolumns ( resource $connection_id , int $type , string $qualifier , string $owner , string $table , int $scope , int $nullable )
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.
Parameters
-
connection_id
-
The ODBC connection identifier, see odbc_connect() for details.
-
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.
-
owner
-
The owner.
-
table
-
The table.
-
scope
-
The scope, which orders the result set.
-
nullable
-
The nullable option.
Return Values
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
© 1997–2017 The PHP Documentation Group
Licensed under the Creative Commons Attribution License v3.0 or later.
https://secure.php.net/manual/en/function.odbc-specialcolumns.php