What is the purpose of the database schema?

advertisements

What is the purpose of database schema? Where can I find more information about this? It's not table, it's not database, what is it?


From the quackit.com tutorial – SQL Server - Database Schemas:

A database schema is a way to logically group objects such as tables, views, stored procedures etc. Think of a schema as a container of objects.

You can assign a user login permissions to a single schema so that the user can only access the objects they are authorized to access.

Schemas can be created and altered in a database, and users can be granted access to a schema. A schema can be owned by any user, and schema ownership is transferable.