DeZign for Databases v2.3 Description:
is a database development tool that uses entity relationship diagrams to graphically design databases. It visually supports the layout of the entities and relationships and automatically generates SQL-schema's for most leading databases. DeZign for Databases also supports domains (user defined types).
Features of DeZign for Databases include: an entity relationship diagram (ERD) editor; full support for ER modeling techniques; fast graphics manipulation; automatic schema-generation (DDL); full control over schema-output; the ability to define indexes; automatic foreign key migration at design-time; automatic resolution of many-to-many relationships; template driven schema-creation; and open type mapping.
It also provides support for: full cardinality and connectivity; weak entity-types; multiple display modes; and high-level auto-increment datatypes. You can export diagrams as BMP or GIF images, and you can export the data dictionary.
DeZign for Databases allows you to generate constraints as table-constraints, column-constraints or use the alter table statement. You can also directly generate dBase or Paradox-tables, and Microsoft Access modules for database-creation. It Includes a powerful report generator, and provides version control for your entity relationship diagrams.
The databases supported include: Oracle, Interbase, IBM DB2, Sybase, Microsoft Access, Microsoft SQL Server, Paradox, dBase, Informix, SQL-Anywhere, MySQL. Support for the MySQL enum-datatype is also provided.