Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

DROP REMOTE MESSAGE TYPE statement [SQL Remote]

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.

Must have DBA authority. To be able to drop the type, there must be no user granted REMOTE or CONSOLIDATE permissions with this type.

Automatic commit.

• CREATE REMOTE MESSAGE TYPE statement [SQL Remote]
• Using message types.

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

DROP REMOTE MESSAGE TYPE file;