I spent half a day writing tests against MS SQL where tests would create a separate schema, do their business, then the schema dropped via "DROP SCHEMA ... CASC

I spent half a day writing tests against MS SQL where tests would create a separate schema, do their business, then the schema dropped via "DROP SCHEMA ... CASCADE". In the end, thanks to Meat Intelligence on the web I found out there is no CASCADE for MS SQL. But only because blogs and documentation etc were written by people who kinda mostly checked what they wrote.