User's Manual

DROP REMOTE MESSAGE TYPE statement
Function 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
Parameters
Parameter Description
message-system One of the message systems supported by 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 “DROP REMOTE MESSAGE TYPE statement [SQL Remote]” [ASA SQL
Reference, page 460]
“CREATE REMOTE MESSAGE TYPE statement” on page 357
“ALTER REMOTE MESSAGE TYPE statement” on page 355
“sp_drop_remote_type procedure” on page 388
“Using message types” on page 210.
362