Deletes a stable queue. Use this command to drop a failed materialization queue.
Use sysadmin drop_queue to stop and delete a materialization queue that remains after a subscription experiences an unrecoverable error and must be manually cleaned up.
Use admin who to find the q_number and q_type for a queue. The values appear in the command’s SQM thread output.