DROP REMOTE MESSAGE TYPE statement [SQL Remote]

Deletes a message type definition from a database.

Syntax

DROP REMOTE MESSAGE TYPE message-system

message-system : 
FILE 
| FTP 
| SMTP

Remarks

The statement removes a message type from a database.

Privileges

You must have the SYS_REPLICATION_ADMIN_ROLE system role.

Side effects

Automatic commit.

Standards

Example

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

DROP REMOTE MESSAGE TYPE FILE;