DROP MESSAGE msgnum

None.

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.

• PRINT statement [T-SQL]
• CREATE MESSAGE statement [T-SQL]
• ISYSUSERMESSAGE system table

Drop MyMessage from the database. If the message does not exist, an error is returned.

DROP MESSAGE MyMessage;