Command Console › Command Console Workspace › Use the SQL Assistant

Use the SQL Assistant

The SQL Assistant is a Wizard-driven tool that automates the process of creating an SQL script. You can choose the type of command that you want through a series of dialogs.

To use the SQL Assistant

1. Select a dictionary from the Select Dictionary drop-down list box.
2. Start the SQL Assistant by clicking the SQL Assistant button on the Command Console toolbar or by selecting the SQL Assistant command from the Script menu.

   The Choose Type of Statement dialog opens, enabling you to pick the type of SQL command statement that you want to execute.

   

3. Make your selection and click Next.

   The first of three Choose Objects dialogs displays. Here you can select the Tables, Table Procedures, Views, and Non-SQL Tables that you want to use as objects.

   

4. Click Next.

   A dialog displays where you specify the columns that you want to include in your results. Click Next to continue.

   

5. Next, the Ordering and Criteria dialog opens where you can choose the order of the columns and the sort type (ascending or descending) for the column. Click finish.

   The SQL statements execute and the results are displayed in the Results pane.