Skip to main content

Explore - SQL Explorer​

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