ASA SQL Reference

SQL Statements

DROP REMOTE MESSAGE TYPE statement [SQL Remote]

Description 

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

Usage 

The statement removes a message type from a database.

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 [SQL Remote]
• sp_drop_remote_type procedure
• Using message types.

Example 

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

DROP REMOTE MESSAGE TYPE file

SQL Anywhere Studio 9.0.1
Copyright © 1989–2004 Sybase, Inc. Portions copyright © 2001–2004 iAnywhere Solutions, Inc. All rights reserved.