SQLDBrowser is a practical and useful tool designed to quickly explore the information stored in SQL Server databases. .
The first objective of SQLDBrowser is to increase the productivity of those using SQL databases allowing them instant access to information.
With SQLDBrowser, developers and IT analysts have at their disposal an effective way to quickly explore the databases to easily understand their architecture and design.
List of features:
. Displaying all the data in a single window: all data tables that are linked to the main table are displayed in the same window. There is no limit to the number of displayed tables.
. Navigation by using 'Join' mode or 'Where' mode: in the first mode, queries are generated with the keyword 'JOIN'. In the second mode, queries are generated with the keyword 'WHERE'.
. Navigation in the structure of the database: any secondary table can become the main table which allows the display of all related tables making it possible to explore the structure of the database.
. Choice of tables to be included in the navigation: SQLDBrowser allows to choose the tables to be included in the navigation, this is useful for example to focus on a particular domain. However, during navigation it is also possible to exclude desired tables or add new ones.
. Choice of visible fields when browsing: by default all fields for a table are displayed but it is possible to hide those desired.
Possibility of hiding tables with no rows: a button on the toolbar allows to hide all the tables that have no data related to the current query.
. Display data in a form or in a grid: all displayed tables (primary and secondary) have a button that allows the two modes view. In both cases, it is possible to browse through the rows of the result by using the buttons: first, next, last and last.
. Changing the SQL query of the main table: it is possible to edit and modify the query of the main table generated by SQLDBrowser.
|