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