Delete a queue via Database

Currently I run some tests with OTRS.

I searched for a possibility to delete the waste queues and found somewhere a tip to do that via deleting the records in the database.

Proceed:

• Removing constraint:

  ALTER TABLE queue_standard_response DROP FOREIGN KEY ‘FK_queue_standard_response_queue_id_id’;

• Deleting the records

  For one thing in the queue table, and for another thing in the queue_standard_response table.

• ADD constraint again

  ALTER TABLE queue_standard_response ADD CONSTRAINT FK_queue_standard_response_queue_id_id FOREIGN KEY (queue_id) REFERENCES queue (id);

The problem is, that I still see the deleted queues in Queue Manager also after clearing the browser cache. Out of which table is OTRS fetching these information?

Do someone have a solution?

It's the local OTRS application cache. If you'd run bin/otrs.DeleteCache.pl on the command line, you'd be fine.