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
Any user who owns the object, or has DBA authority, can execute the DROP MESSAGE statement.
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.
Drop MyMessage from the database. If the message does not exist, an error is returned.
DROP MESSAGE MyMessage;