db2_special_columns

db2_special_columns

Returns a result set listing the unique row identifier columns for a table

resource **db2_special_columns** resource $connection  $qualifier string $schema string $table_name int $scope

Returns a result set listing the unique row identifier columns for a table.

connectionA valid connection to an IBM DB2, Cloudscape, or Apache Derby database.

qualifierA qualifier for DB2 databases running on OS/390 or z/OS servers. For other databases, pass null or an empty string.

schemaThe schema which contains the tables.

table_nameThe name of the table.

scopeInteger value representing the minimum duration for which the unique row identifier is valid. This can be one of the following values:

Returns a statement resource with a result set containing rows with unique row identifier information for a table. The rows are composed of the following columns:

db2_column_privileges``db2_columns``db2_foreign_keys``db2_primary_keys``db2_procedure_columns``db2_procedures``db2_statistics``db2_table_privileges``db2_tables