Home SQL Server Commands
 

ALTER MESSAGE TYPE

Change properties of a message type.

Syntax
      ALTER MESSAGE TYPE message_type
VALIDATION =
{ NONE
| EMPTY
| WELL_FORMED_XML
| VALID_XML WITH SCHEMA COLLECTION schema_collection }
[;] Key: NONE - The message body may contain any data. EMPTY - The message body must be NULL WELL_FORMED_XML - The message body must contain well-formed XML. WITH SCHEMA COLLECTION - XML that conforms to a schema in the collection specified.

Both sides of a conversation must define the same name for a message type.

Example

 ALTER MESSAGE TYPE
[//SS64.com/Sample/SubmitSample]
VALIDATION = WELL_FORMED_XML ;

"Don't kill the messenger" - Sophocles 442 B.C.

Related commands:

CREATE MESSAGE TYPE
DROP MESSAGE TYPE
ALTER AUTHORIZATION

Equivalent Oracle commands:

DBMS_AQ
DBMS_AQELM
UTL_HTTP



Back to the Top

Simon Sheppard
SS64.com