database schema

A Database Schema is the skeleton structure that represents the logical view of the entire database. It defines how the data is organized and how the relations are associated. It formulates all the constraints that are to be applied to the data.

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.