Create a new SQL Script
To create an SQL script:
- Open Run SQL Scripts.
- From the Run SQL Scripts window, select New.
- Manually create your statements, insert examples from the Examples list, or retrieve the SQL for an existing
object using the generate SQL function.
- After you have finished creating your statements, you can check the syntax of your statement by selecting
Check Syntax from the Run menu.
- When syntax checking is complete, select Save from the File
menu. You are prompted for the location and name of the script.
Tip:
- To check the syntax of the entire script before running Check Syntax, you should
select Smart Statement Selection from the Options menu and select
Select All from the Edit menu.