Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
Removes a message from the database.
DROP MESSAGE msgnum
You must be owner, or have the DROP MESSAGE or DROP ANY OBJECT system privilege.
Automatic commit. Clears the Results tab in the Results pane in Interactive SQL.
DROP MESSAGE supplies the functionality provided by the sp_dropmessage() system procedure in Adaptive Server Enterprise.
The following example creates and then drops a new message. To run this example, you must also have the CREATE MESSAGE system
CREATE MESSAGE 20000 AS 'End of line reached';
DROP MESSAGE 20000;