Table (database)

A table is a named database structure that organizes related records into rows and attributes into columns. Its schema defines the columns and their data types.

Database record: A database record is a collection of related values representing one entity or event. Each row stores one record in the table.
SQL: SQL is a language for defining, querying, and modifying data in relational databases. SQL statements create tables and retrieve or change their rows.
Database normalization: Database normalization organizes relational data to reduce redundancy and update anomalies. Normalization guides how information is divided among related tables.
View (SQL): A SQL view is a named query that presents data from underlying tables without storing its result as ordinary rows. A view looks table-like but is defined by a query rather than stored as a base table.
Database column: A database column is a named attribute whose values share a defined data type. Columns specify the attributes recorded for every row.
Relational algebra: Relational algebra is a formal system of operations on relations, including selection, projection, and join. Its operations provide the mathematical basis for querying tables.
Check constraint: A check constraint restricts column values to those satisfying a specified condition. It enforces a rule on the values stored in table rows.
Document-oriented database: A document-oriented database stores records as self-contained documents, often with varying structures. Documents can vary in shape where table rows follow a defined schema.
Database schema: A database schema is the formal structure of a database, including its tables, columns, and constraints. The table's columns and rules are defined within a schema.
Database index: A database index is an auxiliary structure that speeds up data retrieval using selected columns. An index can make searches on table columns faster.

Linked from 1 page

DatabaseBroader topic: Tables are a common way to divide this database’s information into structured collections.