title: SQL Server 2008 delete all tables under special schema
body: <p>Hello I would like to know is is possible to drop all  tables in database what was created under custom schema for example DBO1...with one sql query or special script.</p>
  
  <p>Thanks </p>