sys.service_contract_message_usages (Transact-SQL)


THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

This catalog view contains a row per (contract, message type) pair.

Column nameData typeDescription
service_contract_idintIdentifier of the contract using the message type. Not NULLABLE.
message_type_idintIdentifier of the message type used by the contract. Not NULLABLE.
is_sent_by_initiatorbitMessage type can be sent by the conversation initiator. Not NULLABLE.
is_sent_by_targetbitMessage type can be sent by the conversation target. Not NULLABLE.

The visibility of the metadata in catalog views is limited to securables that a user either owns or on which the user has been granted some permission. For more information, see Metadata Visibility Configuration.

Community Additions