Query Editor Dialog Box

The Query Editor dialog box allows you to configure the query editor settings in Interactive SQL.

ComponentDescription
Fully qualify table and column names

Select this to have Interactive SQL prefix table names with the owner (for example, dbo.authors) and prefix column names with the owner and table names (for example, dbo.titles.price).

Quote names

Select this to automatically put quotes around table and columns names to avoid conflicts with reserved words.

Get list of tables on startup

Select this to automatically get a list of tables in the database when the query editor is started.