Class ServiceBrokerSchema.ServiceMessageType

sys.service_message_types (Transact-SQL)

Applies to: √ SQL Server (all supported versions)

This catalog view contains a row per message type registered in the service broker.

[Table(Schema = "sys", Name = "service_message_types", IsView = true)]
public class ServiceBrokerSchema.ServiceMessageType

Properties

Identifier of the message type, unique within the database. Not NULLABLE.

[Column("message_type_id")]
[NotNull]
public int MessageTypeID { get; set; }

Name of message type, unique within the database. Not NULLABLE.

[Column("name")]
[NotNull]
public string Name { get; set; }

Identifier for the database principal that owns this message type. NULLABLE.

[Column("principal_id")]
[Nullable]
public int? PrincipalID { get; set; }

Validation done by Broker prior to sending messages of this type. Not NULLABLE. One of:

N = None

X = XML

E = Empty

[Column("validation")]
[NotNull]
public string Validation { get; set; }

Description of the validation done by Broker prior to sending messages of this type. NULLABLE. One of:

NONE

XML

EMPTY

[Column("validation_desc")]
[Nullable]
public string? ValidationDesc { get; set; }

For validation that uses an XML schema, the identifier for the schema collection used.

Otherwise, NULL.

[Column("xml_collection_id")]
[Nullable]
public int? XmlCollectionID { get; set; }