Data Replication with SQL Remote
   PART 4. Reference
     CHAPTER 17. Command Reference for Adaptive Server Anywhere       

DROP REMOTE MESSAGE TYPE statement

Function 

To delete a message type definition from a database.

Syntax 

DROP REMOTE MESSAGE TYPE message-system

Parameters 

Parameter	Description
message-system	One of the message systems supported by SQL Remote. It must be one of the following values: FILE FTP MAPI SMTP VIM

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 

CREATE REMOTE MESSAGE TYPE statement

ALTER REMOTE MESSAGE TYPE statement

Using message types.

Description 

The statement removes a message type from a database.

Example 

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

DROP REMOTE MESSAGE TYPE file