You can only modify the SQL name and description of the SQL statement stored in the SQL Repository.
To modify SQL name or description
From the SQL Repository window, select the SQL you want to modify from the left pane.
Right-click and select Modify.
Modify the name and/or description. Click OK to save changes to the SQL Repository. The Last modified field will automatically be updated once the information is saved.
Note: SQL text cannot be modified. You must delete the current SQL and recreating a new one to change the SQL text.