User Guide > Views and Table Resources > Ad Hoc SQL and the SQL Scratchpad Editor
 
Ad Hoc SQL and the SQL Scratchpad Editor
TDV provides an ad hoc SQL editor a SQL Scratchpad editor that let you execute “anonymous” SQL statements that are not bound to a resource. You can define and execute any SQL statements that can be executed for a composite view.
Ad hoc SQL content and history are saved on the local (Studio instance) machine, and retrieved in the following Studio session.
These topics are covered:
Opening the SQL Scratchpad Editor
Composing and Executing an Ad Hoc SQL Query
The SQL Scratchpad History Pane
The SQL Scratchpad Result Panel