Query: db2_primary_keys
OS: php
Section: 3
Format: Original Unix Latex Style Formatted with HTML and a Horizontal Scroll Bar
DB2_PRIMARY_KEYS(3) 1 DB2_PRIMARY_KEYS(3) db2_primary_keys - Returns a result set listing primary keys for a tableSYNOPSISresource db2_primary_keys (resource $connection, string $qualifier, string $schema, string $table-name)DESCRIPTIONReturns a result set listing the primary keys for a table.PARAMETERSo $connection - A valid connection to an IBM DB2, Cloudscape, or Apache Derby database. o $qualifier - A qualifier for DB2 databases running on OS/390 or z/OS servers. For other databases, pass NULL or an empty string. o $schema - The schema which contains the tables. If $schema is NULL, db2_primary_keys(3) matches the schema for the current connection. o $table-name - The name of the table.RETURN VALUESReturns a statement resource with a result set containing rows describing the primary keys for the specified table. The result set is com- posed of the following columns: +------------+---------------------------------------------------+ |Column name | | | | | | | Description | | | | +------------+---------------------------------------------------+ | TABLE_CAT | | | | | | | Name of the catalog for the table containing the | | | primary key. The value is NULL if this table does | | | not have catalogs. | | | | |TABLE_SCHEM | | | | | | | Name of the schema for the table containing the | | | primary key. | | | | |TABLE_NAME | | | | | | | Name of the table containing the primary key. | | | | |COLUMN_NAME | | | | | | | Name of the column containing the primary key. | | | | | KEY_SEQ | | | | | | | 1-indexed position of the column in the key. | | | | | PK_NAME | | | | | | | The name of the primary key. | | | | +------------+---------------------------------------------------+SEE ALSOdb2_column_privileges(3), db2_columns(3), db2_foreign_keys(3), db2_procedure_columns(3), db2_procedures(3), db2_special_columns(3), db2_statistics(3), db2_table_privileges(3), db2_tables(3). PHP Documentation Group DB2_PRIMARY_KEYS(3)
Related Man Pages |
---|
db2_column_privileges(3) - php |
db2_columns(3) - php |
db2_special_columns(3) - php |
alzabo::create::table(3pm) - debian |
sql::translator::schema(3pm) - debian |
Similar Topics in the Unix Linux Community |
---|
Content extract of a file using awk |
IBM DB2 Product Suite |
Create a table - very new to unix |
Run DB2 export command in loop |
Asynchronous I/O on AIX and DB performance |