title: Difference between database and schema
body: <p>What's the difference between a Database and a Schema in SQL Server? Both are the containers of tables and data.</p>
  
  <p>If a Schema is deleted, then are all the tables contained in that schema also deleted automatically or are they deleted when the Database is deleted?</p>