A queue is a full database object, like a table or a stored procedure. As such, it is part of a schema, and appears in the
sys.objectsview. A queue holds messages that have been sent to it, in the same way that a table does, and these messages can even be queried in the same way that you would query a table.
You can’t change the columns that are available, and there are quite a few of them. To see what there is, just run
SELECT *against any queue, but a few of the key ones are service_name, service_contract_name, message_type_name, message_body, message_enqueue_time, conversation_handle.
Read on to see how to create a new queue.