Unique Keys
Go Up to Supported Objects
Unique keys can enforce logical keys that are not chosen as the primary key. They enforce uniqueness for specified columns in a table.
Creating and editing
- Unique Keys Wizard (DB2 LUW) and Unique Keys Editor (IBM DB2 LUW)
- Unique Keys Wizard (DB2 Z/OS) and Unique Keys Editor (IBM DB2 Z/OS)
- Indexes, Primary Keys, or Unique Keys wizard (MySQL) and Indexes, Primary Keys, and Unique Keys editors (MySQL)
- Unique Keys Wizard (Oracle) and Unique Keys Editor (Oracle)
- Exclusion Constraints, Primary Keys, and Unique Keys Wizards (PostgreSQL) and Exclusion Constraints, Primary Keys, or Unique Keys Editors (PostgreSQL)
- Unique Keys Wizard (SQL Server) and Unique Keys Editor (SQL Server)
- Unique Keys Wizard (Sybase ASE) and Unique 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 | |
---|---|---|---|---|---|---|---|---|
✓ |
||||||||
✓ |
||||||||
✓ |
||||||||
✓ |
||||||||
✓ |
||||||||
✓ |
✓ |
✓ |
✓ |
✓ |
✓ |
✓ |
✓ | |
✓ |
✓ |
✓ |
✓ |
✓ |
✓ |
✓ |
✓ | |
✓ |
✓ |
✓ |
✓ |
✓ |
✓ |
|||
✓ |
✓ |
|||||||
✓ |
✓ |
✓ |
✓ |
✓ |
✓ |
|||
✓ |
||||||||
✓ |
✓ |
✓ |
✓ |
✓ |
✓ |
|||
✓ |