Jump to content

Table (database)

From Simple English Wikipedia, the free encyclopedia

In a database, a table is a way of laying out information in columns and rows. A common way to use this data is through SQL. The columns identify attributes, the rows are items of data. Usually there is a subset of columns which uniquely identifies the row. When talking about databases, this is called a primary key.

Not all tables are stored as tables in the database. One example that looks like a table, but that is not stored as one is a database view. A database view is the result of executing a given query. It is usually not stored, but recalculatted each time it is needed.