Delete a user-defined procedure or function.

 

Syntax

 

<drop routine statement> ::=

 

 

 

DROP <routine type> [ IF EXISTS ] [ schema-name. ] routine-name [ RESTRICT ]

 

<routine type> ::=

 

|

|

 

ROUTINE

FUNCTION

PROCEDURE

 

 

Usage

 

The DROP ROUTINE statement deletes the procedure or function specified by routine-name from the database.

 

 

Notes

 

The current database is implicit if a schema name is not specified.



 

ROUTINE can be specified to indicate that the routine type can be either procedure or function.



 

If PROCEDURE or FUNCTION is specified, then the routine being deleted must be the specified type.



 

The IF EXISTS clause can be specified to avoid an exception when attempting to delete a routine that does not exist in the database.



 

RESTRICT, which is implicit if not explicitly specified, prevents the routine from being deleted if the routine is referenced by other database objects.



 

The DROP ROUTINE statement requires exclusive access to the routine being deleted.



 

 

Examples

 

1)

The following example deletes the getStudents function:



 


DROP FUNCTION IF EXISTS getStudents



 

2)

The following example deletes the getStudents function using the ROUTINE keyword:



 


DROP ROUTINE IF EXISTS getStudents



 

3)

The following example deletes the studentNames procedure:



 


DROP PROCEDURE IF EXISTS studentNames



 

 


 

Conformance

 

SQL:2003 standard

 

NexusDB extensions

-

 

-

Core SQL

 

IF EXISTS clause