摘要:
本文将深入探讨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
Comments NOTHING