What is a Schema?
Published July 23, 2025
By Sai Sree Ram Gundepudi
What is a Schema?
A schema is a logical container that holds tables, views, procedures, indexes, and other database objects under one user namespace.
Example:
In Oracle, each user gets a schema. A user named HR owns all objects created under it like HR.employees.
Use Case:
Schemas allow you to separate data logically between applications or modules.