With the main menu Tools > Explore > SQL Explorer option, you can use your existing SQL Connection or create new SQL Connections with the wizard to browse databases, tables and perform queries.
Tools > Explore > SQL Explorer
Connections tree and connecting
The connections tree shows the same Connections you see in the Connections window (if there is any SQL Connection).
There are 5 levels in the Connections tree:
- Connection name
- - Database name
- - - Tables
- - - - list of tables
- - - Views
- - - - list of vies
- - - Stored procedures
- - - - list of stored procedures
- - - - - Arguments to stored procedures
You will access these sub items by either double clicking on a Connection or right click and select Connect.
When connected you can:
•Open and edit a table by double clicking on a table
•Perform edit in form and grid view
•Delete rows
•Scroll through rows
•Filter rows
•Click on new query button to perform your own SQL query against any open connection
•Execute any stored procedure with parameters