User's Guide

Part VI. SQL Anywhere Reference

Chapter 43. Watcom-SQL Statements

Function

To delete a message type definition from a database.

Syntax

     DROP REMOTE MESSAGE TYPE message-system

Parameters

     message-system:
          MAP| FILE| VIM| SMTP

Usage

Anywhere. This statement is applicable only to SQL Remote.

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
• "SQL Remote 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