Table (database)

tabletablesdatabase tabledatabase tablesdata tablesrelationrelational data tablesrelational database tablesrelational tablestable data structure
A table is a collection of related data held in a table format within a database.wikipedia
161 Related Articles

Database

database management systemdatabasesDBMS
A table is a collection of related data held in a table format within a database.
These model data as rows and columns in a series of tables, and the vast majority use SQL for writing and querying data.

Relational database

relational database management systemRDBMSrelational databases
In relational databases, and flat file databases, a table is a set of data elements (values) using a model of vertical columns (identifiable by name) and horizontal rows, the cell being the unit where a row and column intersect.
This model organizes data into one or more tables (or "relations") of columns and rows, with a unique key identifying each row.

Row (database)

rowsrowrecord
In relational databases, and flat file databases, a table is a set of data elements (values) using a model of vertical columns (identifiable by name) and horizontal rows, the cell being the unit where a row and column intersect. It consists of columns, and rows.
In the context of a relational database, a row—also called a tuple—represents a single, implicitly structured data item in a table.

Primary key

Alternate keydefining database keykey
A specific choice of columns which uniquely identify rows is called the primary key.
In the relational model of databases, a primary key is a specific choice of a minimal set of attributes (columns) that uniquely specify a tuple (row) in a relation (table).

Table (information)

tabletabulartables
A table is a collection of related data held in a table format within a database.

Check constraint

constraints constraintconstraints
Besides the actual data rows, tables generally have associated with them some metadata, such as constraints on the table or on the values within particular columns.
A check constraint is a type of integrity constraint in SQL which specifies a requirement that must be met by each row in a database table.

Select (SQL)

SELECTSQL query keyword
However, the database system does not guarantee any ordering of the rows unless an clause is specified in the statement that queries the table.
The SQL SELECT statement returns a result set of records from one or more tables.

SQL

Structured Query LanguageSQL databaseSQL Databases
For instance, a SQL table can potentially contain duplicate rows, whereas a true relation cannot contain duplicate rows that we call as tuples.

Relation (database)

relationrelation schemarelations
"Table" is another term for "relation"; although there is the difference in that a table is usually a multiset (bag) of rows where a relation is a set and does not allow duplicates. In terms of the relational model of databases, a table can be considered a convenient representation of a relation, but the two are not strictly equivalent.
In SQL, a database language for relational databases, relations are represented by tables, where each row of a table represents a single tuple, and where the values of each attribute form a column.

Relational model

relationalrelational data modelrelationships
In terms of the relational model of databases, a table can be considered a convenient representation of a relation, but the two are not strictly equivalent.
A table is an accepted visual representation of a relation; a tuple is similar to the concept of a row.

Column (database)

columnscolumnAttribute
In relational databases, and flat file databases, a table is a set of data elements (values) using a model of vertical columns (identifiable by name) and horizontal rows, the cell being the unit where a row and column intersect. It consists of columns, and rows.

Flat-file database

flat fileflat file databaseflat files
In relational databases, and flat file databases, a table is a set of data elements (values) using a model of vertical columns (identifiable by name) and horizontal rows, the cell being the unit where a row and column intersect.

Multiset

multisetsbagbag (multiset)
"Table" is another term for "relation"; although there is the difference in that a table is usually a multiset (bag) of rows where a relation is a set and does not allow duplicates.

Set (abstract data type)

setsetsset data structure
"Table" is another term for "relation"; although there is the difference in that a table is usually a multiset (bag) of rows where a relation is a set and does not allow duplicates.

Metadata

meta datameta-datacommunications metadata
Besides the actual data rows, tables generally have associated with them some metadata, such as constraints on the table or on the values within particular columns.

View (SQL)

viewviewsdatabase view
Views also function as relational tables, but their data are calculated at query time.

IBM Informix

InformixInformix Dynamic ServerIBM Informix Dynamic Server
External tables (in Informix

Tuple

tuplesn-tuple5-tuple
For instance, a SQL table can potentially contain duplicate rows, whereas a true relation cannot contain duplicate rows that we call as tuples.

Order by

SQL ORDER BY timestamp clause
However, the database system does not guarantee any ordering of the rows unless an clause is specified in the statement that queries the table.

Graphics

graphicgraphicalgraph
An equally valid representation of a relation is as an n-dimensional chart, where n is the number of attributes (a table's columns).

Hierarchical database model

hierarchical modelhierarchical databasehierarchical
In non-relational systems, hierarchical databases, the distant counterpart of a table is a structured file, representing the rows of a table in each row of the file and each column in a row.

Computer file

filefilescomputer files
In non-relational systems, hierarchical databases, the distant counterpart of a table is a structured file, representing the rows of a table in each row of the file and each column in a row.

Spreadsheet

spreadsheetscellspreadsheet program
Unlike a spreadsheet, the datatype of a column is ordinarily defined by the schema describing the table.

Data type

typedatatypetypes
Unlike a spreadsheet, the datatype of a column is ordinarily defined by the schema describing the table.