Other forms: schemas
A schema is the shape a database expects its data to have. Define the schema, a schema change, the schema is fixed.
Changing one on a live system is among the more nerve-racking jobs in software, since every existing row has to fit. The plural is schemas or schemata, and scheme is the same Greek word arrived by another road.
1nounschemaThe shape a database expects its data to have.
“Before adding the new column, the developers had to update the database schema.”
schema is a structure.
Greek schema means a form or shape; scheme is a doublet.
Proto-Indo-European
*seǵʰ-
Ancient Greek
σχῆμα — form, shape
Latin
schēma
English, today
schema
Latin schēma, from Ancient Greek σχῆμα (“form, shape”). a doublet of scheme.
Etymology from Wiktionary, CC BY-SA