Schema
noun
say it: “SKEE-muh” /ˈskimə/
The planned structure of a database's data: which tables or fields exist, what each holds and how they relate.
What is Schema in a relational database?
Schema — The named structure defining database objects such as tables, views, and constraints.
CREATE SCHEMA sales;
In a sentence
- “MongoDB doesn't force one schema on a collection, though validation can add one.”
- “Adding a column changes the table's schema, so every row gets it.”
Level: Novice · More Database terms at this level
Updated