DROP REMOTE MESSAGE TYPE message-system

message-system : 
FILE 
| FTP 
| SMTP

The statement removes a message type from a database.

You must have the SYS_REPLICATION_ADMIN_ROLE system role.

Automatic commit.

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

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

DROP REMOTE MESSAGE TYPE FILE;