Sybase Technical Library - Product Manuals Home
[Search Forms] [Previous Section with Hits] [Next Section with Hits] [Clear Search] Expand Search
Using stored procedures as security mechanisms [Table of Contents] System procedures

Transact-SQL User's Guide

[-] Chapter 14 Using Stored Procedures
[-] Dropping stored procedures

Dropping stored procedures

Use drop procedure to remove stored procedures. Its syntax is: 

drop proc[edure] [owner.]procedure_name 
     [, [owner.]procedure_name] ...

If a stored procedure that was dropped is called by another stored procedure, Adaptive Server displays an error message. However, if a new procedure of the same name is defined to replace the one that was dropped, other procedures that reference the original procedure can call it successfully.

A procedure group, that is, more than one procedure with the same name but with different numbered suffixes, can be dropped with a single drop procedure statement. Once procedures have been grouped, procedures within the group cannot be dropped individually.

Using stored procedures as security mechanisms [Table of Contents] System procedures