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 |
|
Database |
|
Schema |
|
Table |
|
Object Table |
|
Temporary Table |
|
Index Organized Table |
|
Encrypted Table |
|
External Table |
|
Remote Table |
|
View |
|
Materialized View |
|
Domain1 |
|
Column |
|
Primary Key Column |
|
Required Column |
|
Computed Column |
|
Index, possible mixed sort order |
|
Index, ascending sort order |
|
Index, descending sort order |
|
Expression Index |
|
Primary Key Constraint |
|
Unique Constraint |
|
Check Constraint |
|
Foreign Key Constraint |
|
Trigger |
|
Database Trigger |
|
.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 |
|
User |
|
Role |
|
Group |
|
Login Policy |
|
Encryption Key |
|
Linked Server/Remote Server |
|
Data File/Table Space |
|
Server Certificate |
|
LDAP Server |
|
|
|
1.Called "User Defined Data-types" in MS SQL Server
2.Called "Extended Procedures" in MS SQL Server
3.Called "Events" in MySQL
4.Formerly called "Generators" in Firebird, called "Generators" in InterBase