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.
Not in the standard.
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 privilege:
CREATE MESSAGE 20000 AS 'End of line reached'; DROP MESSAGE 20000;