Entity Relationship Diagram

View Entity Relationship Diagrams for related tables.

Select a Database

1. Start by selecting a database connection from the DB Explorer.

2. Choose the desired database.

   

Access the Entity Relationship Diagram

1. Hover over Tables in the database menu.

2. Right-click to open the context menu, then select Entity Relationship Diagram.

   

3. A new tab will open, displaying the Entity Relationship Diagram. You can adjust the layout of the diagram by dragging tables to reorganize the view.

Multiple Schema Support

When you open an Entity Relationship Diagram, you can select which schemas to include:

1. Right-click on Tables in the DB Explorer.

2. Select Entity Relationship Diagram from the context menu.

3. The toolbar shows a schema selector when the database has more than one schema. It lists every schema; picking one loads its tables on demand.

4. All selected schemas show in the diagram. Use Select All or Deselect All to select everything or nothing.

Diagram Layout

Related tables are laid out by their relationships; tables with none sit in a compact block below. Use Hide tables without relationships to hide that block, or Reset table positions to re-run the layout after dragging tables around.

Interactive ERD Example

Here’s an interactive example of what an Entity Relationship Diagram looks like in DBCode. This example was created using DBCode’s share feature, which allows you to publish your ERDs as interactive web pages:

Open in new window ↗

Export and Share Options

DBCode provides multiple ways to export and share your Entity Relationship Diagrams, making it easy to document your database design or share it with team members and stakeholders.

Export as PDF

Generate a professional PDF version of your ERD:

1. Once the Entity Relationship Diagram is open, look for the Export / Share button in the toolbar.

2. Choose PDF format from the export options.

3. Optional: Set a password to protect the PDF content for sensitive database schemas.

Export as PNG

Save your ERD as a high-resolution image:

1. Click the Export / Share button in the toolbar.

2. Choose PNG format from the export options.

3. The diagram will be saved as a high-resolution PNG image, perfect for embedding into documents, presentations, or wikis.

Share as Web Page

Create an interactive HTML version that can be viewed in any browser:

1. Click the Export / Share button in the toolbar.

2. Choose Web Page format from the export options.

3. Optional: Configure sharing permissions and set an expiration date.

4. Get a secure link to share with others or download the HTML file.

Interactive Features:

• Zoomable Interface: Viewers can zoom in and out to explore diagram details
• Draggable Tables: Interactive layout adjustment for better viewing
• Responsive Design: Optimized for viewing on desktop, tablet, and mobile devices
• Search Functionality: Find specific tables or relationships quickly

Secure Share

Publish your ERD securely using DBCode’s sharing feature:

1. Open your Entity Relationship Diagram in DBCode.

2. Click the Export / Share button in the toolbar.

3. Configure sharing permissions, access controls, and expiration settings.

4. Generate a secure link to share with team members or stakeholders.

Learn more about secure sharing in our Data Sharing documentation.