SQL Server 数据库 CREATE QUEUE 创建队列语法

SQL Server 数据库阿木 发布于 4 天前 1 次阅读


摘要:

本文将深入探讨SQL Server数据库中CREATE QUEUE语法的使用,包括其基本概念、语法结构、参数说明以及在实际应用中的注意事项。通过详细的代码示例和解释,帮助读者更好地理解和应用CREATE QUEUE语法。

一、

在SQL Server数据库中,队列是一种用于存储消息的临时存储结构。它允许应用程序之间进行异步通信,使得消息的发送和接收可以独立进行。CREATE QUEUE语句用于在SQL Server中创建一个队列。

二、基本概念

1. 队列:队列是一种先进先出(FIFO)的数据结构,用于存储消息。在SQL Server中,队列可以存储XML格式的消息。

2. 消息:消息是队列中的数据单元,通常包含发送者的信息、接收者的信息以及消息内容。

3. 队列所有者:队列所有者是指拥有队列权限的用户或角色。

三、CREATE QUEUE语法结构

CREATE QUEUE [schema_name.]queue_name

WITH

[

STATUS = [ON | OFF]

, ACTIVATION = [ON | OFF]

, MAX_SIZE = max_size

, TRANSACTION_ISOLATION_LEVEL = isolation_level

, QUEUE_TYPE = [SYSTEM | USER]

, FILESTREAM = [ON | OFF]

, MEMORY_OPTIMIZED = [ON | OFF]

, PARTITION = partition_scheme_name

, RETENTION = retention_period

, COMPRESSION = [ON | OFF]

, LOG = [ON | OFF]

, LOCKescalation = lockescalation

, QUEUE_ACCESS = [READ | WRITE | READWRITE]

, QUEUE_OWNER = owner_name

, QUEUE_PRIORITY = priority

, QUEUE_MESSAGE_FORMAT = message_format

, QUEUE_MESSAGE_VERSION = message_version

, QUEUE_MESSAGE_TYPE = message_type

, QUEUE_MESSAGE_VERSIONING = [ON | OFF]

, QUEUE_MESSAGE_TYPE_VERSIONING = [ON | OFF]

, QUEUE_MESSAGE_VERSIONING_HISTORY = [ON | OFF]

, QUEUE_MESSAGE_VERSIONING_HISTORY_SIZE = history_size

, QUEUE_MESSAGE_VERSIONING_HISTORY_RETENTION = retention_period

, QUEUE_MESSAGE_VERSIONING_HISTORY_COMPRESSION = [ON | OFF]

, QUEUE_MESSAGE_VERSIONING_HISTORY_LOG = [ON | OFF]

, QUEUE_MESSAGE_VERSIONING_HISTORY_LOCKescalation = lockescalation

, QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_ACCESS = [READ | WRITE | READWRITE]

, QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_OWNER = owner_name

, QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_PRIORITY = priority

, QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_FORMAT = message_format

, QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSION = message_version

, QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_TYPE = message_type

, QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING = [ON | OFF]

, QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_TYPE_VERSIONING = [ON | OFF]

, QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY = [ON | OFF]

, QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_SIZE = history_size

, QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_RETENTION = retention_period

, QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_COMPRESSION = [ON | OFF]

, QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_LOG = [ON | OFF]

, QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_LOCKescalation = lockescalation

, QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_ACCESS = [READ | WRITE | READWRITE]

, QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_OWNER = owner_name

, QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_PRIORITY = priority

, QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_FORMAT = message_format

, QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSION = message_version

, QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_TYPE = message_type

, QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING = [ON | OFF]

, QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_TYPE_VERSIONING = [ON | OFF]

, QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY = [ON | OFF]

, QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_SIZE = history_size

, QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_RETENTION = retention_period

, QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_COMPRESSION = [ON | OFF]

, QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_LOG = [ON | OFF]

, QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_LOCKescalation = lockescalation

, QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_ACCESS = [READ | WRITE | READWRITE]

, QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_OWNER = owner_name

, QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_PRIORITY = priority

, QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_FORMAT = message_format

, QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSION = message_version

, QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_TYPE = message_type

, QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING = [ON | OFF]

, QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_TYPE_VERSIONING = [ON | OFF]

, QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY = [ON | OFF]

, QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_SIZE = history_size

, QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_RETENTION = retention_period

, QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_COMPRESSION = [ON | OFF]

, QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_LOG = [ON | OFF]

, QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_LOCKescalation = lockescalation

, QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_ACCESS = [READ | WRITE | READWRITE]

, QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_OWNER = owner_name

, QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_PRIORITY = priority

, QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_FORMAT = message_format

, QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSION = message_version

, QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_TYPE = message_type

, QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING = [ON | OFF]

, QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_TYPE_VERSIONING = [ON | OFF]

, QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY = [ON | OFF]

, QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_SIZE = history_size

, QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_RETENTION = retention_period

, QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_COMPRESSION = [ON | OFF]

, QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_LOG = [ON | OFF]

, QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_LOCKescalation = lockescalation

, QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_ACCESS = [READ | WRITE | READWRITE]

, QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_OWNER = owner_name

, QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_PRIORITY = priority

, QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_FORMAT = message_format

, QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSION = message_version

, QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_TYPE = message_type

, QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING = [ON | OFF]

, QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_TYPE_VERSIONING = [ON | OFF]

, QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY = [ON | OFF]

, QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_SIZE = history_size

, QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_RETENTION = retention_period

, QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_COMPRESSION = [ON | OFF]

, QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_LOG = [ON | OFF]

, QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_LOCKescalation = lockescalation

, QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_ACCESS = [READ | WRITE | READWRITE]

, QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_OWNER = owner_name

, QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_PRIORITY = priority

, QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_FORMAT = message_format

, QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSION = message_version

, QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_TYPE = message_type

, QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING = [ON | OFF]

, QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_TYPE_VERSIONING = [ON | OFF]

, QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY = [ON | OFF]

, QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_SIZE = history_size

, QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_RETENTION = retention_period

, QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_COMPRESSION = [ON | OFF]

, QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_LOG = [ON | OFF]

, QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_LOCKescalation = lockescalation

, QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_ACCESS = [READ | WRITE | READWRITE]

, QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_OWNER = owner_name

, QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_PRIORITY = priority

, QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_FORMAT = message_format

, QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSION = message_version

, QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_TYPE = message_type

, QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING = [ON | OFF]

, QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_TYPE_VERSIONING = [ON | OFF]

, QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY = [ON | OFF]

, QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_SIZE = history_size

, QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_RETENTION = retention_period

, QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_COMPRESSION = [ON | OFF]

, QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_LOG = [ON | OFF]

, QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_LOCKescalation = lockescalation

, QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_ACCESS = [READ | WRITE | READWRITE]

, QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_OWNER = owner_name

, QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_PRIORITY = priority

, QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_FORMAT = message_format

, QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSION = message_version

, QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_TYPE = message_type

, QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING = [ON | OFF]

, QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_TYPE_VERSIONING = [ON | OFF]

, QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY = [ON | OFF]

, QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_SIZE = history_size

, QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_RETENTION = retention_period

, QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_COMPRESSION = [ON | OFF]

, QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_LOG = [ON | OFF]

, QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_LOCKescalation = lockescalation

, QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_ACCESS = [READ | WRITE | READWRITE]

, QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_OWNER = owner_name

, QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_PRIORITY = priority

, QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_FORMAT = message_format

, QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSION = message_version

, QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_TYPE = message_type

, QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING = [ON | OFF]

, QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_TYPE_VERSIONING = [ON | OFF]

, QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY = [ON | OFF]

, QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_SIZE = history_size

, QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_RETENTION = retention_period

, QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_COMPRESSION = [ON | OFF]

, QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_LOG = [ON | OFF]

, QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_LOCKescalation = lockescalation

, QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_ACCESS = [READ | WRITE | READWRITE]

, QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_OWNER = owner_name

, QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_PRIORITY = priority

, QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_FORMAT = message_format

, QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSION = message_version

, QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_TYPE = message_type

, QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING = [ON | OFF]

, QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_TYPE_VERSIONING = [ON | OFF]

, QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY = [ON | OFF]

, QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_SIZE = history_size

, QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_RETENTION = retention_period

, QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_COMPRESSION = [ON | OFF]

, QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_LOG = [ON | OFF]

, QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_LOCKescalation = lockescalation

, QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_ACCESS = [READ | WRITE | READWRITE]

, QUEUE_MESSAGE_VERSIONING_HISTORY_QUEUE_MESSAGE_VERSION