Progress
SQL-92
Guide and Reference


DROP PROCEDURE Statement

Deletes a stored procedure.

SYNTAX

DROP PROCEDURE [ owner_name.]procedure_name ; 

owner_name

Specifies the owner of the procedure.

procedure_name

Name of the stored procedure to delete.

EXAMPLE

DROP PROCEDURE new_sal ; 

AUTHORIZATION

Must have DBA privilege or owner of a stored procedure.

SQL COMPLIANCE

SQL-92, ODBC Core SQL grammar

ENVIRONMENT

Embedded SQL, ODBC applications, JDBC applications

RELATED STATEMENTS

CALL Statement, CREATE PROCEDURE Statement


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095