Use this statement to delete a message type definition from a database.
DROP REMOTE MESSAGE TYPE message-system
message-system: FILE | FTP | MAPI | SMTP | VIM
The statement removes a message type from a database.
Support for VIM and MAPI is deprecated.
Must have DBA authority. To be able to drop the type, there must be no user granted REMOTE or CONSOLIDATE permissions with this type.
The following statement drops the FILE message type from a database.
DROP REMOTE MESSAGE TYPE file;