A reader, November 04, 2020 - 4:07 am UTC
It worked for me.
A reader, July 26, 2023 - 1:39 pm UTC
This query worked for me. User dropped in just few minutes
Thanks you very much
August 03, 2023 - 10:30 am UTC
glad we could help
Ha, October 30, 2023 - 1:23 am UTC
great solution. Thanks very much
October 30, 2023 - 5:42 am UTC
glad we could help
Drop schema Vs drop objects....
Rajeshwaran, July 01, 2025 - 2:16 pm UTC
July 03, 2025 - 12:47 pm UTC
It seems to me Tom was more focused on simplicity than speed - DROP USER ... CASCADE is undeniably simpler.
I would still say dropping a schema is still uncommon. The rise of CI/CD pipelines that build the whole schema from scratch means it's more common now. Whether it's common enough to be worth putting development effort into optimizing drop user depends on how pressing a problem this is for customers.