The Database Builder

The Database Builder is a tailored interface for the data modeler; all database-related modeling tasks can be performed in a single location. The interface and its related screens include only the information relevant to data modeling, thereby streamlining and simplifying the modeling process.

Access

Ribbon

Design > Tools > Database Builder

Database Builder

This collection of images shows the pages of the Database Builder and the typical information that they allow the user to modify.

Database Builder

This figure shows the Database Builder loaded with the 'Orders (postgres)' data model as it appears in the Example model.

Overview

The interface of the Database Builder consists of:

A Tree of data models, listing all defined data models in the current repository

A 'Columns'tab through which you directly manage the Table columns

A 'Constraints/Indexes'tab for the direct management of Table constraints such as Primary Keys, Foreign Keys and Indexes

An SQL Scratch Pad that you can use to run ad-hoc SQL queries against a live database

A 'Database Compare' tab that displays the results of comparisons between the data model and a live database

An 'Execute DDL' tab on which you can execute generated DDL against a live database, instantly