Database Workbench has a unique image for each type of object and modifications of some images to show the difference between occurrences of the same object type.
Below is a table with each object type.
Icon |
Object Description |
|
Schema |
|
Table |
|
Object Table |
|
Temporary Table |
|
Index Organized Table |
|
Encrypted Table |
|
External Table |
|
View |
|
Materialized View |
|
Domain1 |
|
Field |
|
Primary Key Field |
|
Required Field |
|
Computed Field |
|
Index, possible mixed sort order |
|
Index, ascending sort order |
|
Index, descending sort order |
|
Expression Index |
|
Index, inactive |
|
Index, ascending sort order, inactive |
|
Index, descending sort order, inactive |
|
Expression Index, inactive |
|
Primary Key Constraint |
|
Unique Constraint |
|
Check Constraint |
|
Foreign Key Constraint |
|
Trigger |
|
Database Trigger |
|
Trigger, inactive |
|
Database Trigger, inactive |
|
.NET Assembly |
|
XML Schema or XML Schema Collection |
|
Stored Procedure |
|
Stored Function |
|
Stored Module/Package |
|
Stored Module Header/Package Header |
|
Stored Module Body/Package Body |
|
External Function2 |
|
Scheduled Job3 |
|
Object Type |
|
Collection Type |
|
Type Attribute |
|
Java Source |
|
Library |
|
Directory |
|
Sequence4 |
|
Synonym |
|
Public Synonym |
|
Database User |
|
Database Role |
|
| 1. | Called "User Defined Data-types" in MS SQL Server |
| 2. | Called "Extended Procedures" in MS SQL Server |
| 3. | Called "Events" in MySQL |
| 4. | Called "Generators" in Firebird and InterBase |