Tip: Drop All Tables/Sequences from a User

I was testing a deployment script today and after about 10 tables something would fail. And it took a few goes to get it right (silly leading spaces). So I was getting very frustrated manually dropping all tables and constraints I had just built. So I did a bit of digging and came across this: select ‘DROP TABLE [SCHEMA_NAME].’ || TABLE_NAME || ‘ CASCADE CONSTRAINTS;’ … Continue reading Tip: Drop All Tables/Sequences from a User