What is database Schema?
Schemas are namespaces, i.e. logical containers with database objects like tables, views or procedures. Every user has a default schema assigned that has the same name like the user.
a single application runs in a single schema but Data can be separated using different database schemas. The catalog contains all schemas that include the respective column and row tables.
Schemas are used to categorize a database content.according to customer defined groupings that have a particular meaning for users.
Schemas also help to define access rights to the database objects.
Note:
From a modeling standpoint, schemas can help to identify which tables to use when defining information models. But a model can incorporate tables from multiple schemas. Schemas do not limit your modelling capabilities
