Table Categories

The DB tree separates objects such as tables, views, routines, and sequences by type. In ERD workflows, you find tables from these categories, add them to the current ERD, or refresh them.

DB Tree Categories

TABLES and VIEWS are separated by default, and categories such as INDEXES, SEQUENCES, ROUTINES, TRIGGERS, and EVENTS are added depending on the DBMS.

CategoryRelation to ERD
TABLESA list of regular tables that can be added to an ERD.
VIEWSRead-only/query objects. Some editing can be restricted compared with regular tables.
ROUTINESGroups FUNCTIONS and PROCEDURES together in DBMSs such as PostgreSQL and Oracle.
Other objectsUsed more often from object detail tabs or SQL generation than as direct ERD table nodes.

Add from Category to ERD

Tables in the TABLES category can be dragged onto the canvas or added to the current ERD from the context menu. A specific-Schema ERD allows only tables from the same Schema, while an all-Schema ERD can also include tables from other Schemas in the same Connection and Database.

Note:

Tables marked as system Schema appear in grayscale/locked state, and structural changes are restricted.

When an ERD tab is active, the related Connection, Database, and Schema are highlighted in the left DB tree, and the tree automatically scrolls to make that location visible.

Refresh Categories

Refresh on a category node reloads that category list. Refresh when tables were changed externally or when the list looks stale after applying DB changes from the ERD.

SituationRecommended Action
Table created externallyRefresh the Schema or TABLES category.
List update after DDL ImportIf needed, refresh the TABLES category and confirm the imported table.
Check structure after applying to DBRefresh the table or category to inspect the latest structure.

DBMS Differences

Category composition differs by DBMS. For example, PostgreSQL and Oracle functions/procedures can be grouped as ROUTINES in the tree, and some DBMSs may not show certain categories.