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 | |
---|---|---|---|---|---|---|---|---|
✓ |
||||||||
✓ |
||||||||
✓ |
||||||||
✓ |
||||||||
✓ |
||||||||
✓ |
✓ |
✓ |
✓ |
✓ |
✓ |
✓ |
✓ | |
✓ |
✓ |
✓ |
✓ |
✓ |
✓ |
✓ |
✓ | |
✓ |
✓ |
✓ |
✓ |
✓ |
✓ |
|||
✓ |
✓ |
|||||||
✓ |
✓ |
✓ |
✓ |
✓ |
✓ |
✓ |
||
✓ |
||||||||
✓ |
✓ |
✓ |
✓ |
✓ |
✓ |
✓ |