Skip to Main Content
SQL in a Nutshell
book

SQL in a Nutshell

by Kevin Kline
December 2000
Intermediate to advanced content levelIntermediate to advanced
224 pages
9h 52m
English
O'Reilly Media, Inc.
Content preview from SQL in a Nutshell

Name

DROP PROCEDURE

Synopsis

This command destroys an existing stored procedure in the current user database.

Vendor

Command

SQL Server

Supported

MySQL

Not supported

Oracle

Supported

PostgreSQL

Not supported

SQL99 Syntax and Description

DROP PROCEDURE procedure_name {RESTRICT | CASCADE}

This command is essentially the same as DROP FUNCTION, except that it acts upon stored procedures rather than functions.

Microsoft SQL Server Syntax and Variations

DROP PROCEDURE [owner_name.]procedure_name [,...n]

Microsoft SQL Server allows the removal of multiple stored procedures by placing a comma between the name of each one. Individual versions of stored procedures cannot be dropped. The entire group of stored-procedure versions must be dropped.

Oracle Syntax and Variations

DROP PROCEDURE [owner_name.]procedure_name

Oracle also allows any procedure to be dropped based on the owner name. Users with the system privilege, DROP ANY PROCEDURE, may drop procedures owned by other users.

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

SQL in a Nutshell, 3rd Edition

SQL in a Nutshell, 3rd Edition

Kevin Kline

Publisher Resources

ISBN: 1565927443