This documentation is archived and is not being maintained.

Deleting Stored Procedures and User-Defined Functions

When you no longer need a stored procedure or user-defined function, you can delete it from the database.

To delete a stored procedure

  1. In Server Explorer, expand the Stored Procedures folder.
  2. Right-click the stored procedure that you want to delete.
  3. Choose Delete on the shortcut menu.
  4. A message prompts you to confirm the deletion. Choose Yes.

The stored procedure is deleted from the database and Server Explorer.

To delete a user-defined function

  1. In Server Explorer, expand the Functions folder.
  2. Right-click the function that you want to delete.
  3. Choose Delete on the shortcut menu.
  4. A message prompts you to confirm the deletion. Choose Yes.

The user-defined function is deleted from the database and Server Explorer.

See Also

Working with Stored Procedures and User-Defined Functions

Show: