Database Editor

Graphical Database Design

To make database editing and design easier, DatabaseSpy lets you view and edit the structures of all your databases through one graphical user interface. You can examine tables and relationships in an existing database to understand them more easily, you can edit existing database tables, or you can add tables and specify all their column attributes and relationships to other tables from scratch.

The graphical editing approach allows you to concentrate on the underlying structure of your data and any required modifications rather than the SQL commands required to implement them. As you work, the DatabaseSpy graphical database designer automatically constructs the SQL statements you will need, but you choose when to execute the database structure change script once all your edits are complete.

Because it supports multiple databases, DatabaseSpy automatically adjusts the contents of pull-down lists of data types and other specialized features.

You can view the structure of any existing table in your database by dragging it from the database browser into the database design pane or by selecting it and choosing Show in Design Editor from the context menu. The table and column details are immediately displayed in the database designer graphical view.

The graphical image of each table includes compartments you can expand to view in greater detail or collapse so you can concentrate on table relationships, which are clearly indicated with connecting lines.

You can edit table column names and attributes directly in the graphical table display, or add a new column, index, key, or constraint by clicking icons, or via a right-click context menu. You can also edit existing entries directly in the design window or in the properties helper window.