USE MyData;
GO

— Drop failed because schema is not empty
DROP SCHEMA Sch;
GO
Msg 3729, Level 16, State 1, Line 1
Cannot drop schema ‘Sch’ because it is being referenced
   by object ‘DF__sch_test__creat__4316F928’.

— Move one table out
ALTER SCHEMA dbo TRANSFER Sch.test;
GO

— Delete one table
DROP TABLE Sch.test;
GO

— Dropped ok
DROP SCHEMA Sch;
GO

Command(s) completed successfully.