Over a million developers have joined DZone.

DbSchema 5.7.1 is here

DZone's Guide to

DbSchema 5.7.1 is here

· ·
Free Resource
DbSchema is a database tool designed to be an easy-to-use software, no matter if you are a professional SQL developer or a novice user. It is one of the best solutions, since it can be used on all major operating systems and it can be used on a wide range of databases.
We are proud of the quality and user-friendliness of our software



Top Four Features:

1.       Layout

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.

{{ parent.title || parent.header.title}}

{{ parent.tldr }}

{{ parent.urlSource.name }}