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