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 
| SMTP
Remarks

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
Standards and compatibility
  • SQL/2003   Vendor extension.

Example

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

DROP REMOTE MESSAGE TYPE file;