Create a new SQL Script

To create an SQL script:

  1. Open Run SQL Scripts.
  2. From the Run SQL Scripts window, select New.
  3. Manually create your statements, insert examples from the Examples list, or retrieve the SQL for an existing object using the generate SQL function.
  4. After you have finished creating your statements, you can check the syntax of your statement by selecting Check Syntax from the Run menu.
  5. When syntax checking is complete, select Save from the File menu. You are prompted for the location and name of the script.

Tip: