Table

In relational databases, SQL databases, and flat file databases, a table is a set of data elements that is controlled using a model of horizontal rows and vertical columns. The columns are identified by name, and the rows are identified by the values appearing in a particular column division which has been identified as a candidate key. Table is another term for family although there is the difference in that a table is usually a multi-set of rows whereas a relation is a set and does not allow duplicates. A table has a particular number of columns but can have any number of rows. Besides the actual data rows, tables generally have related with them some meta-information, such as constraints on the table or on the values within particular columns.

The data in a table does not have to be actually stored in the database. Views are also relational tables, but their data is considered at query time. In non-relational systems, such as hierarchical databases, the isolated counterpart of a table is a structured file, representing the rows of a table in each record of the file and each column in a record.