Unix and Linux Discussions Tagged with primary |
|
Thread / Thread Starter |
Last Post |
Replies |
Views |
Forum |
|
|
|
1 |
3,968 |
Solaris |
|
|
|
1 |
2,550 |
Shell Programming and Scripting |
|
|
|
2 |
7,838 |
AIX |
|
|
|
0 |
4,171 |
UNIX for Advanced & Expert Users |
|
|
|
7 |
50,272 |
UNIX for Dummies Questions & Answers |
|
|
|
2 |
3,184 |
IP Networking |
|
|
|
3 |
5,754 |
UNIX for Dummies Questions & Answers |
|
|
|
3 |
2,392 |
UNIX for Dummies Questions & Answers |
|
|
|
3 |
6,337 |
UNIX for Dummies Questions & Answers |
|
|
|
4 |
4,537 |
UNIX for Dummies Questions & Answers |
|
|
|
9 |
5,351 |
IP Networking |
|
|
|
5 |
3,224 |
UNIX for Dummies Questions & Answers |
|
|
|
2 |
3,583 |
IP Networking |
|
|
|
1 |
11,704 |
Programming |
|
|
|
2 |
2,285 |
UNIX for Dummies Questions & Answers |
|
|
|
1 |
6,113 |
UNIX for Dummies Questions & Answers |
|
|
|
6 |
4,047 |
IP Networking |
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)