What is the use of a schema in SQL Server?

What is the use of a schema in SQL Server?

Advantage of Schema:-

  1. Act as object protection tool: A schema can be a very effective object projection tool combined with the appropriate level of user permissions. 
  2. A DBA can maintain control access to an object that would be very crucial.
  3. Easy to maintain the database.
  4. A single schema can be shared among multiple databases and database users.
  5. A database user can be dropped without dropping database objects.
  6. Manipulation of and access to the object is now very complex and more secure. The schema acts as an additional layer of security.
  7. Database objects can be moved among schemas.
  8. The ownership of schemas is transferable