subject: Dbschema In Informix [print this page] Create multiple diagrams ( layouts ) to design and edit your schema. Is enough to move the mouse over a foreign key to see the corresponding columns, to double-click a table to edit it or drag a column over another to create a foreign key. Foreign keys can be drawn joined to tables or to columns, so you can see exactly which columns are joined.
Working online the schema changes will be applied in DbSchema and in the database. Working offline the schema changes will be done only in DbSchema and saved in the project file. Later you can decide to synchronize the schema with the database and commit the schema changes or refresh changes from Db. You can convert your schema to a different database, upload it on database...
An amazingly simple and efficient relational data explorer that offers simultaneous views of data from multiple tables and features numerous filters, data sorting mechanisms, and much more.
The Sql editor with syntax highlighting and code completion, makes your editing easier, productive and can even be fun. Supports execution of simple queries or large scripts, with output on screen or spool to file.
Graphically compose complex queries with INNER, OUTER, EXISTS joins, filters and group by clauses. This in a visual way, using diagrams, for a better understanding of the relations between tables.
DbSchema supports documentation from the ground up, allowing every table, column, index, etc. to have an associated comment or description. DbSchema can generate documentation in visual graphical format, compact ( XHTML / SVG ) for an easy deploy over web. You can view your schema remote, move the mouse over the tables and columns and read the comments.
The DbSchema project file will store the schema design and the layouts with the SQL and Data Browse editors. The project file can be opened from any other computer, even if you cannot connect to the database.
