Schema Explorer

The Schema Explorer gives you a live view of your database structure. It's the left panel in Zentro, below the project navigator.

What You Can Browse

• Tables — all tables in the connected database, with row count estimates
• Columns — name, data type, nullable, default value, primary key flag
• Indexes — index name, type, columns covered
• Foreign keys — references to other tables, with direction
• Views — listed separately from tables
• Stored procedures — listed per database (PostgreSQL functions, SQL Server stored procs)

Navigating the Tree

Click any table to expand it and see its columns. Double-clicking a table opens a Table View in the editor area, showing the first 200 rows.

Right-clicking a table gives you:

• Open Table — view all rows in the Data Grid
• Copy SELECT * — pastes a select query to the active editor tab
• View DDL — shows the CREATE TABLE statement
• Refresh — re-fetches structure from the database

Search

Press Ctrl+F while the Schema Explorer has focus to search table and column names. The tree filters live as you type.

Switching Databases

For connections that have multiple databases (e.g. MySQL), a database selector appears at the top of the Schema Explorer. Switching databases re-fetches the schema for the selected database without disconnecting.

ERD Button

An ERD button at the top of the Schema Explorer opens the Entity-Relationship Diagram view for the current schema.

→ See ERD Visualization