Home
SQL programmingYou can use the HCL OneDB™ implementation of the SQL language to develop applications for HCL OneDB™ database servers.
Guide to SQL: SyntaxThe HCL OneDB™ Guide to SQL: Syntax describes the syntax of the statements, data types, expressions, operators, and built-in functions of the HCL OneDB™ dialect of the SQL language.
SQL statementsThis chapter describes the syntax and semantics of SQL statements that are recognized by HCL OneDB™.
DROP ROUTINE statementUse the DROP ROUTINE statement to remove a user-defined routine (UDR) from the database.

DROP ROUTINE statement

Use the DROP ROUTINE statement to remove a user-defined routine (UDR) from the database.

This statement is an extension to the ANSI/ISO standard for SQL.

Syntax

Notes:

¹ See Specific Name


Element	Description	Restrictions	Syntax
owner	Name of UDR owner	Must own the UDR	Owner name
parameter_type	Data type of a parameter of routine	The data type (or list of data types) must be the same type (and specified in the same order) as in the UDR definition	Identifier; Data Type
routine	Name of the UDR to drop	The UDR must exist (that is, be registered) in the database	Identifier

Usage

Dropping a UDR removes the text and executable versions of the UDR from the database. If you do not know whether a UDR is a user-defined function or a user-defined procedure, this statement instructs the database server to drop the specified user-defined function or user-defined procedure.

To use the DROP ROUTINE statement, you must be the owner of the UDR (and also hold the Resource privilege on the database), or you must have the DBA privilege. You must also hold the Usage privilege on the programming language in which the UDR is written. To drop an external user-defined routine, see also Dropping an External Routine.