The SQL item in the Database menu or the~ 
~ toolbar button opens a window where all SQL statements are displayed that are accessible to you. In
this window, you can design and save new SQL statements, and execute, modify, or delete existing ones.
Initially, this window will be empty and you will only be able to design new SQL statements. To do so, select New. In the following window, you can then enter the SQL statement. If an SQL query is involved, you may view its result before saving it. Select Execute and a window with the result appears. Of course, you can use this result at once (see Section Viewing and Modifying the Result of a Query). If it is the desired result, you can save the SQL statement with Save. Its name can have a maximum length of 150 characters.
If there are already saved SQL statements or if you share SQL statements with other users (see Section New Sharing of Stored Objects), these SQL statements are displayed, ordered by owner. Click on the title bar to order the SQL statements by their names. In the title bar, you can see whether the SQL statements are ordered by owner or by name; the sort column is not enclosed in brackets.
If other users allow you to share their SQL statements, you can execute these statements. The owner of an SQL statement to be shared can determine whether the sharing user may only execute the statement or also read it. If you share an SQL statement for execution only, then you cannot change it. If you share it for reading, you can modify and save it as your own SQL statement.
See also:
Specifying Several SQL Statements
Executing Saved SQL Statements
Modifying and Deleting Saved SQL Statements