- From the SP Test tool, right-click anywhere on the tree view; then click
Edit List of Stored Procedures Displayed.
- If you have checked
Also remove from database, the SP Test tool invokes the File Name to Save Drop Commands dialog box. Here, you specifiy the name of a command file that the SP Test tool generates to drop the checked stored procedures from their XDB location(s). The SP Test tool executes this command file when you click
Save.
- Check the box to the right of each stored procedure you want to remove from the list.
- If you want to remove the checked stored procedures from the repository as well as the displayed list, check
Also remove from database (optional).
- Click
Remove to remove the checked stored procedures.
Note: If you leave
Also remove from database unchecked, stored procedures you have removed from the list reappear when you start the Stored Procedure Test tool again, or when you click
Refresh list of stored procedures
.
