DbSchema 5.7.1 is here
DbSchema 5.7.1 is here
Join the DZone community and get the full member experience.Join For Free
We are proud of the quality and user-friendliness of our software
Top Four Features:
DbSchema comes with interactive diagrams also called layouts. With the help of the layouts you can easily create tables, columns, foreign keys, callouts with a few simple clicks. This feature will help you also when working with a big database and having lots of table is going to give you a big headache. All you have to do is create a new layout, add tables to the layout by simply drag and drop from the structure tree and add further child tables by pressing the foreign key icon near one of the columns.
The major advantage is a better understanding of the database schema.
2. Relational Data Browse
Tired of having to search for records in multiple tables?
DbSchema has the solution, Relational Data Browse has an amazingly simple and efficient data explorer. You can start viewing the data from a table, add further child tables by pressing the foreign key near one of the column, and the matching records will show on all tables.
You can build a complex relational data browse with optional data filters without any limitation in size, this is a new alternative for the traditional SQL Queries, intuitive and easy to use.
3. SQL Editor
With the SQL Editor you can write and execute SQL Queries, it integrates many features like:
Autocomplete, Execute Scripts, Explain Plan, SQL Formatter and much more.
4. SQL Builder
Complex queries are giving you a hard time?
Build complex queries with a few clicks using our Query Builder.
Simply drag & drop the tables you need from the layout, add further child tables by pressing the foreign key near one of the columns, selecting the columns with different join types, where clauses and ordering, you may build complex queries, without being an advanced SQL developer.
You can view or copy the query generated in the preview window.
The data can be saved in different formats: XML, CSV, XLS, etc…
Help And Support:
Our team is offering many support features, including video tutorials, email facilities and other forms of help as and when you need them. These mainly help to teach you more about the software to use it effectively.
The top 3 reasons to get DbSchema:
1. Easy to use
2. Get all major software releases and bug fix releases that are released during the protection period
3. Devoted Customer Support Team
Opinions expressed by DZone contributors are their own.