DROP REMOTE MESSAGE TYPE message-system

message-system : 
FILE 
| FTP 
| SMTP

The statement removes a message type from a database.

DBA authority, and there must be no user granted REMOTE or CONSOLIDATE permissions with this type.

Automatic commit.

• CREATE REMOTE MESSAGE TYPE statement [SQL Remote]
• SQL Remote message systems
• Deleting message types

The following statement drops the FILE message type from a database.

DROP REMOTE MESSAGE TYPE file;