SQL Server does not support to drop a Schema with the cascade option in its DROP schema statement.
Tabulify supports it, you can drop a schema with the cascade option in the drop operation