odbc_specialcolumns
(PHP 4, PHP 5, PHP 7, PHP 8)
odbc_specialcolumns — Retrieves special columns
說明
odbc_specialcolumns(
resource
int
?string
string
string
int
int
): resource|false
resource
$odbc,int
$type,?string
$catalog,string
$schema,string
$table,int
$scope,int
$nullable): resource|false
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.
參數
-
odbc 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. -
catalog The catalog ('qualifier' in ODBC 2 parlance).
-
schema The schema ('owner' in ODBC 2 parlance).
-
table The table.
-
scope The scope, which orders the result set. One of
SQL_SCOPE_CURROW,SQL_SCOPE_TRANSACTIONorSQL_SCOPE_SESSION.-
nullable Determines whether to return special columns that can have a NULL value. One of
SQL_NO_NULLSorSQL_NULLABLE.
返回值
Returns an ODBC result identifier or false on
failure.
The result set has the following columns:
SCOPECOLUMN_NAMEDATA_TYPETYPE_NAMECOLUMN_SIZEBUFFER_LENGTHDECIMAL_DIGITSPSEUDO_COLUMN
The result set is ordered by SCOPE.
參見
- odbc_tables() - Get the list of table names stored in a specific data source