You can only modify the SQL name and description of the SQL statements stored in the SQL Repository.
To modify the name or description
-
From the SQL Repository window, select the SQL you want to modify from the left pane.
-
Right-click and select Modify to open the Modify SQL window.
-
Modify the name and/or description.
Note: SQL text cannot be modified. You must delete the current SQL and recreating a new one to change the SQL text.