 |
 |
|
|
 |
 |
|
|
|
|
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.
|
|
Editor review: Reviewer, 2009-01-13 10:39:00
Offering easy accessibility to the entire data stored with SQL Server databases, the SQLDBrowser 1.0.1 proves to be rather beneficial in a DBAs work profile. Using the application, you can easily explore the SQL database information without getting into any hassles. It supports the developers in comprehending the database architecture and design. The application is further capable of showing all data tables linked to main table within the same window. It is incorporated with unlimited number of tables, which are easily navigable according to your preferences. Furthermore, its range of features include- query generation in two modes, allows navigation within table structure, selection of specific tables and fields for exploring, hide tables with data irrelevant to current query, view data in form or grid mode, change SQL query of main table, and many more.
Once you use SQLDBrowser to connect to the SQL database, you can begin exploring the data tables to view the desired information, in a trouble-free manner. The tables of the connected database are displayed at the left pane of the program window. From these tables you can easily mark specific tables to view the information you’re looking for. You can further navigate within tables to explore sub-tables, and while exploring these, the related table columns are displayed on the mid part of the left panel. Further, the SQL detail is shown below columns section. The columns can be marked to view the data in the display window on the right. While exploring the database info, you can generate SQL query within two mode ‘JOIN’ and ‘WHERE’, by using these as keywords. Moreover, you can modify settings of the program to make it work accordingly. All these and even more features are available with the application for conveniently exploring the SQL database information.
The SQLDBrowser 1.0.1 makes it rather easy for developers to explore the SQL database content, by using suitable query mode, along with other browsing features. For its uncomplicated set of options, quick functionality, and impressive performance, the program is worthily assigned 4 rating points.
|
|
|
Visit homepage of SQLDBrowser
Download SQLDBrowser 1.0.1
Popular search terms related to SQLDBrowser:
grid, productivity, query, domain, navigation, sql, toolbar, hide, browse, fields
|
grid data
sql query
best ip hide
sql query tool
query sql
sql server tool
database form
form database
hide any window
access table
Programs related to SQLDBrowser
|
