php man page for db2_primary_keys

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 table

SYNOPSIS
resource db2_primary_keys (resource $connection, string $qualifier, string $schema, string $table-name)
DESCRIPTION
Returns a result set listing the primary keys for a table.
PARAMETERS
o $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 VALUES
Returns 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 ALSO
db2_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_table_privileges(3) - php
db2_columns(3) - php
db2_foreign_keys(3) - php
db2_statistics(3) - php
db2_special_columns(3) - php
Similar Topics in the Unix Linux Community
IBM DB2 Product Suite
Run script to export the data to ixf file in loop
Dynamically checking rules in database tables using SQL
DB2 in awk
Python Script to take file count and insert into DB2 table