Database Browser - Display databases dynamically
Altova DatabaseSpy® 2017 contains powerful database browser functionality to let you effortlessly explore the organization of tables, views, and stored procedures that make up your database or zero-in precisely on the information you need.
The DatabaseSpy Online Browser lets you connect to multiple databases simultaneously, so you can easily compare their structures and content. You won’t be distracted by the differences between interfaces from different relational database vendors since DatabaseSpy shows all your databases in the same clear, customizable, and easy to navigate display.
You can immediately begin exploring an unfamiliar database by viewing the row count for any table. Simply select it in the hierarchy and click the count link.
You can right-click any table, view, or procedure to open a context menu that lets you instantly retrieve data. You don't need to look up the exact names of the columns that comprise your selection or construct a special SQL query. A menu selection lets you automatically generate a variety SQL statements in the Online Browser based on existing tables and columns, including SELECT, CREATE, INSERT, DROP, and more. You can execute the query immediately or refine it in the SQL Editor window.
Navigate Databases Efficiently
The DatabaseSpy Online Browser is designed to help you easily navigate through large, complex relational databases that can include hundreds of tables, views, and stored procedures, so you can efficiently focus on the most relevant data.
You can choose from five different layouts for the hierarchy display. Or, use the Filter option in the Online Browser toolbar, to apply separate filters for schemas, tables, and views. The Favorites button in the DatabaseSpy Online Browser toolbar lets you show only the items set as project favorites.
The Object Locator tool is a handy way to quickly find a table or database view that is not readily apparent in the Online Browser list. The Object Locater opens an alphabetical list of tables and views in all connected database, regardless of the current Favorites and Filters settings.
Views and Stored Procedures
The DatabaseSpy Database Browser also helps you explore views, stored procedures, and user-defined functions registered in your database. These database objects are stored in specialized sub-folders and identified with unique icons.
You can navigate the database hierarchy to open the Views folder, for instance, then expand the folder to see a list of database views. You can expand any view to identify its columns, and expand any column to examine its constraints and datatype. Similarly, you can expand stored procedures to inspect their parameters.
The right-click context menu offers options appropriate when you want to use or maintain a view or procedure. You easily export the data described by a view, for example, or generate your choice of often-needed SQL statements for the view in a new DatabaseSpy SQL Editor window.
- Firebird 2.5
- IBM DB2 for iSeries® v6.1, 7.1
- IBM DB2® 8, 9.1, 9.5, 9.7, 10.1, 10.5
- Informix® 11.70
- Microsoft Access™ 2003, 2007, 2010, 2013
- Microsoft® Azure SQL
- Microsoft® SQL Server® 2005, 2008, 2012, 2014, 2016
- MySQL® 5, 5.1, 5.5, 5.6
- Oracle® 9i, 10g, 11g, 12c
- PostgreSQL 8, 9.0.10, 9.1.6, 9.2.1, 9.4
- Progress OpenEdge 11.6
- SQLite 3.x
- Sybase® ASE 15