column
A named, typed field that every row of a database table has, such as name or price.
In more detail
Every row has a value for each column, possibly null. Selecting only the columns you need keeps queries fast, and renaming or dropping a column that running code still reads breaks that code.
Example
The migration demo splits a name column into first and last columns.Related terms
- table — A named set of rows that all have the same columns, where each row records one fact about one thing.
- projection — Choosing which fields or columns a query returns, or reshaping each result into a different form.
- expand-and-contract — A way to change a live database in safe steps: add the new structure, move data and code to it, then remove the old structure.
- schema — A formal description of the structure of data: which fields or columns exist, their types and which are required.
- row — One entry in a table, holding one value for each of the table's columns.
- data type — The kind of a value, such as a whole number, text or a date, which decides what you can do with it and how it compares and sorts.
Taught in
- Entity Framework Core: Code First and Migrations — Modern .NET Core, C# & Enterprise Microservices
- Querying, Change Tracking, and Saving Data — Modern .NET Core, C# & Enterprise Microservices
- Database Access & Migrations: ORM & Data Layers — Production Full-Stack Engineering
- Why Tables And Relations Beat Files — PostgreSQL, Indexing & Relational Data Modeling
- The SELECT Statement And Projection — PostgreSQL, Indexing & Relational Data Modeling