When you delete a SQL statement in the SQL Repository, it will delete all references.
To delete a SQL statement stored in the SQL Repository
-
Select the SQL you want to delete.
-
Right-click and select Delete or press the Delete key to delete the selected SQL statement and all references to this SQL statement in other modules.
- If the SQL statement is in an Index Impact Analysis or an Index Usage Analysis, you will be prompted before it is deleted.