I have a schema in Redshift with over 12,000 tables. I want to drop the schema, but the operation isn’t completing due to the large number of tables. I can’t even execute a SELECT query, and there’s no permission error; it’s just that the sheer volume of tables is causing issues. How can I resolve this?
Tried to use Drop schema, Write drop statement, nothing worked.
New contributor
Mariam Siradze is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.