DROP MESSAGE statement

Removes a message from the database.

Syntax

DROP MESSAGE msgnum

Remarks

None.

Privileges

You must be owner, or have the DROP MESSAGE or DROP ANY OBJECT system privilege.

Side effects

Automatic commit.

Standards

ANSI/ISO SQL Standard
Not in the standard.
Transact-SQL
DROP MESSAGE supplies the functionality provided by the sp_dropmessage() system procedure in Adaptive Server Enterprise.

Example

The following example creates and then drops a new message. To run this example, you must also have the CREATE MESSAGE system privilege:

CREATE MESSAGE 20000 AS 'End of line reached';
DROP MESSAGE 20000;