table

A named set of rows that all have the same columns, where each row records one fact about one thing.

In more detail

A table is declared with CREATE TABLE, which lists its columns, their types and their constraints. Rows in a table have no built-in order; you ask for an order with ORDER BY.

Examples

In AWS: A named collection of records in a database: rows in a relational database, or items in DynamoDB.
An order and its outbox event are written to two tables in one transaction.
The SQL course fixture has tables for customers, products, categories, orders, order items and employees.

Related terms

Taught in

References