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

SQL Anywhere 10.0.1 » SQL Anywhere Server - SQL Reference » SQL Statements

DROP PUBLICATION statement [MobiLink] [SQL Remote] Next Page

DROP REMOTE MESSAGE TYPE statement [SQL Remote]


Use this statement to delete a message type definition from a database.

Syntax

DROP REMOTE MESSAGE TYPE message-system

message-system: FILE | FTP | MAPI | SMTP | VIM

Remarks

The statement removes a message type from a database.

Note

Support for VIM and MAPI is deprecated.

Permissions

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

Side effects

Automatic commit.

See also
Example

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

DROP REMOTE MESSAGE TYPE file;