Primary Keys
Go Up to Supported Objects
- Note: This object is supported by all platforms.
Primary Keys are a set of table columns that can uniquely identify every row of a table.
Creating and editing
- Primary Keys Wizard (DB2 LUW) and Primary Keys Editor (IBM DB2 LUW)
- Primary Keys Wizard (DB2 Z/OS) and Primary Keys Editor (IBM DB2 Z/OS)
- Indexes, Primary Keys, or Unique Keys wizard (MySQL) and Indexes, Primary Keys, and Unique Keys editors (MySQL)
- Primary Keys Wizard (Oracle) and Primary Keys Editor (Oracle)
- Exclusion Constraints, Primary Keys, and Unique Keys Wizards (PostgreSQL) and Exclusion Constraints, Primary Keys, or Unique Keys Editors (PostgreSQL)
- Primary Keys Wizard (SQL Server) and Primary Keys Editor (SQL Server)
- Primary Keys Wizard (Sybase ASE) and Primary Keys Editor (Sybase ASE)
- Note: Creation and editing of objects of this type is not supported against Sybase IQ datasources.
DBMS platform availability and object actions/operations supported
The following table lists object actions available for this object type. For an introduction to object actions and details on usage of specific actions, see Object actions.
| DB2 LUW | DB2 z/OS | MySQL | ORCL | PSTGRS * | SQL SVR | SYB ASE | SYB IQ | |
|---|---|---|---|---|---|---|---|---|
|
✓ |
||||||||
|
✓ |
||||||||
|
✓ |
||||||||
|
✓ |
||||||||
|
✓ |
||||||||
|
✓ |
✓ |
✓ |
✓ |
✓ |
✓ |
✓ |
✓ | |
|
✓ |
✓ |
✓ |
✓ |
✓ |
✓ |
✓ |
✓ | |
|
✓ |
✓ |
✓ |
✓ |
✓ |
✓ |
|||
|
✓ |
✓ |
|||||||
|
✓ |
✓ |
✓ |
✓ |
✓ |
✓ |
✓ |
||
|
✓ |
||||||||
|
✓ |
✓ |
✓ |
✓ |
✓ |
✓ |
✓ |