When you connect to a data source in DatabaseSpy, the data source is also displayed in the Online Browser, a powerful tool for analyzing, browsing, and searching for database objects, and for viewing the database structure of multiple databases simultaneously.
The Online Browser gives you an overview of the database objects on the database server(s) to which you are currently connected. Furthermore, you can show the row count for tables and views, generate SQL statements or retrieve data directly from the Online Browser and show them in the SQL Editor, or view the design of a database object in the Design Editor.
The following database objects may be displayed in the Online Browser:
•XML Schemas (for DB2, SQL Server, and Oracle databases)
Different layouts for the objects in the Online Browser can be selected and you can apply filters to different folders as well as use the Object Locator to locate specific database objects in the Online Browser. Furthermore, you can also define favorites to facilitate quick access to objects that you use frequently.
A check box is available in the Online Browser options that, when activated, shows also the connection method in the Project window as well as in the Online Browser together with the data source connection name.