/
SQL Queries for tests

SQL Queries for tests

Owned by Maxim Pokhodin
Mar 05, 2025

Delete test tenants schemes

Somehow during deletion of tenants their schemas are deleted.

Use this SQL query to create a query to find and drop all schemas.

We assume that your pattern for test tenant is testtenant{digits}

select 'drop schema if exists ' || string_agg(schema_name, ', ') || ' cascade' from (select schema_name from information_schema.schemata where schema_name similar to 'testtenant\d%')

It will create another sql query that you need to use to actually drop schemas. It will drop all items within them.

Related content