Table Explorer View

The Advanced SQL Editor provides an extension of the Object Explorer to allow viewing table properties, such as columns, indexes and triggers, under the table note in the explorer tree.

It helps you to write the SQL code in the SQL Editor because you can preview and copy/paste table column names while writing the SQL queries without having to switch to another properties view document.

It also helps you to tune the SQL statements performance by looking up at the existing indexes and index columns without having to switch to a separate table view document.

To copy the object name from the Object Explorer:

1. Select the required object name, such as table, routine or column in the Object Explorer tree.
2. Choose Copy Name from the popup menu.
3. Paste the name into any SQL Editor or text editor using Paste operation.