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.
Design > Tools > Database Builder
This collection of images shows the pages of the Database Builder and the typical information that they allow the user to modify.
This figure shows the Database Builder loaded with the 'Orders (postgres)' data model as it appears in the Example model.
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
You can use the Database Builder to:
- Create, edit and delete database objects (Tables, Views, Procedures, Sequences and Functions)
- Create, edit and delete Table constraints (Primary Keys, Indexes, Unique Constraints, Check Constraints and Triggers)
- Create, edit and delete Table Foreign Keys
- Reverse engineer database schema information
- Generate DDL from a modeled database
- Compare a live database schema with a modeled database
- Execute generated DDL against a live database
- Execute adhoc SQL statements against a live database