To modify a saved SQL statement, select the desired statement and Design. A window appears containing the saved SQL statement. You can modify the statement, view a result with Execute, and save it with Save using either the same name or a new name. If you enter a new name, the old SQL statement will be kept without any changes. Otherwise, the old SQL statement is overwritten with the modified one.
If you modify an SQL statement that another user shares with you, this modified SQL statement is saved as your property.
The modifications are not made to the original statement. If you want the owner of the original SQL statement to be able to use your modified SQL statement, you must share the modified SQL statement with him/her.
For deletion, select the corresponding saved SQL statement and Delete.