Understanding the Difference Between Schema and Data


#1

What’s the difference between a table’s schema and its data?

So, imagine this quick scenario. I have a table called Customer, it is a simple table. It contains three people, each having a unique ID (primary key), Name, Gender, and their Age. This is the schema, which defines the data that will be entered into the table.

And, this is the data for the table:

Our schema defines the data within a table. Distinguishing between data and schema is Important!