PHP.nl

odbc_specialcolumns

odbc_specialcolumns

Retrieves special columns

 **odbc_specialcolumns** Odbc\Connection $odbc int $type  $catalog string $schema 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.

odbc``type When the type argument is , returns the column or columns that uniquely identify each row in the table. SQL_BEST_ROWID``odbc_specialcolumns

   When the type argument is ,
    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.
  `SQL_ROWVER``odbc_specialcolumns`

catalogodbc.parameter.catalog

schemaodbc.parameter.schema

tableThe table.

scope The scope, which orders the result set. One of , or . SQL_SCOPE_CURROW``SQL_SCOPE_TRANSACTION``SQL_SCOPE_SESSION

nullable Determines whether to return special columns that can have a NULL value. One of or . SQL_NO_NULLS``SQL_NULLABLE

odbc.result.object-return-falseforfailure

The result set has the following columns:

odbc.result.driver-specific

  • SCOPE

  • COLUMN_NAME

  • DATA_TYPE

  • TYPE_NAME

  • COLUMN_SIZE

  • BUFFER_LENGTH

  • DECIMAL_DIGITS

  • PSEUDO_COLUMN

    The result set is ordered by . SCOPE

    odbc_tables

Vorige ← odbc_setoption Volgende odbc_statistics →

Documentatie