DatabaseSpy Graphical Database Design Tool

Graphical database design in Altova DatabaseSpy

Database Design Tool Features:

  • Automatically adjusts syntax for different database types
  • Pop-up datatype selection window
  • Edit existing database tables
  • Create new tables and relationships without hand-writing SQL scripts
  • Copy and paste between multiple open design windows
  • Convert existing tables to a new database type
  • Save database diagrams as .png, .bmp, .gif, and .jpg image files
  • Print database table relationship diagrams
  • Auto-generate SQL change scripts
  • Save and reload design files

Download Trial

The Altova DatabaseSpy® 2017 graphical database Design Editor 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 to better suit your needs, or you can add entire tables and specify all their column attributes and relationships to other tables from scratch.

The DatabaseSpy database design tool graphical view 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.

The DatabaseSpy graphical database designer supports multiple databases and automatically adjusts contents of pull-down lists of data types and other specialized features.

Database design change script illustration

Visually Edit Database Tables

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.

Database Change Scripts

As you work in the graphical database Design Editor, DatabaseSpy automatically creates and updates the SQL statements required to implement your changes. You can review the SQL statements directly in the change script window, paste them into a new SQL Editor window, or save the script to a file. You can also execute the script directly or discard your changes if you wish.

Supported Databases:

  • Firebird 2.5
  • IBM DB2 for iSeries® v6.1, 7.1
  • IBM DB2® 8, 9.1, 9.5, 9.7, 10.1, 10.5
  • Informix® 11.70
  • Microsoft Access™ 2003, 2007, 2010, 2013
  • Microsoft® Azure SQL
  • Microsoft® SQL Server® 2005, 2008, 2012, 2014, 2016
  • MySQL® 5, 5.1, 5.5, 5.6
  • Oracle® 9i, 10g, 11g, 12c
  • PostgreSQL 8, 9.0.10, 9.1.6, 9.2.1, 9.4
  • Progress OpenEdge 11.6
  • SQLite 3.x
  • Sybase® ASE 15

Graphically Create New Tables

The DatabaseSpy graphical database Design Editor is a convenient tool for creating completely new tables with multiple columns, keys, and indexes. You can even define relationships to other tables, based on foreign keys.