Saving an SQL statement in the SQL scrapbook

When you save a statement in the SQL scrapbook, you can specify a name and type for the statement, as well as the database with which to associate the statement.

Prerequisite: You must have the statement open in the SQL scrapbook in order to save it.

To save an SQL statement in the SQL scrapbook:

1. Click SQL > Save to Model.

2. Select the database with which you want to associate the statement. Only database tables that have been copied into a project in the Data Definition view are available for selection.

3. In the Statement Type list, select the type of statement that you want your statement to be.

4. Type a name for the statement.

5. To open your statement in the SQL Builder, select the Open saved statement in editor check box.

6. Click OK.

Your statement is saved in the data project that contains the database you specified. If you selected the Open saved statement in editor check box, your statement is opened automatically in the SQL Builder.

 

Parent topic

Creating an SQL statement using the SQL scrapbook

 

Related concepts

SQL Builder