Show/Hide Toolbars

 

Navigation: Client User Interface > Main menu > Tools

Explore - SQL Explorer

Scroll Prev Top Next More

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

ToolsExploreSQLExplorer

 

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