Use this statement to remove a message from the database.

Syntax

DROP MESSAGE msgnum

Remarks

None.

Permissions

Any user who owns the object, or has DBA authority, can execute the DROP MESSAGE statement.

Side effects

Automatic commit. Clears the Results tab in the Results pane in Interactive SQL.

See also

• MESSAGE statement

Standards and compatibility

Example

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

DROP MESSAGE MyMessage;