6 Using SQL Scripts

Use SQL scripts to create, edit, view, run, and delete script files.

• About SQL Scripts
  A SQL script is a set of SQL commands saved as a file in SQL Scripts.
• Accessing SQL Scripts
  Learn how to access SQL Scripts.
• About the SQL Scripts Page
  The SQL Scripts page displays an interactive report of all SQL scripts created by the current user.
• About the Tasks List
  A Tasks list displays on the right side of the SQL Scripts page.
• Creating a SQL Script
  Learn about different ways of creating a SQL script.
• Using the Script Editor
  You use the Script Editor to add content to a new script, to edit existing scripts, and to run and delete scripts in the script repository.
• Creating an Application from a Script
  Launch the Create Application Wizard loaded with pages based on the tables used by the script.
• Deleting a SQL Script
  You can delete scripts from the Script Repository by deleting selected scripts from the SQL Scripts page, or deleting the current script in the Script Editor.
• Copying a SQL Script
  You can copy a script in the Script Repository by saving it with a new name.
• Executing a SQL Script
  You can execute scripts stored in the Script Repository. You can submit a script for execution either from the Script Editor or from the SQL Scripts page.
• Viewing SQL Script Results
  You use the Manage Script Results page to view and delete script results.
• Exporting and Importing SQL Scripts
  Move scripts from your current Script Repository by exporting them and then importing SQL Script Export into a Script Repository in a different workspace.
• Viewing Script and Result Quotas
  You can view the script limits in the current workspace on the Script Quotas page.