Table (database)

tabletablesdatabase tabledatabase tablesdata tablesdatabase filerelationrelational data tablesrelational database tablesrelational tables
A table is a collection of related data held in a table format within a database.wikipedia
163 Related Articles

Database

database management systemdatabasesdatabase systems
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 databasesrelationaldatabase constraints
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.
Table (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)

SELECT keywordSELECTs
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 DatabasesWikibook SQL
For instance, a SQL table can potentially contain duplicate rows, whereas a true relation cannot contain duplicate tuples.
Expressions, which can produce either scalar values, or tables consisting of columns and rows of data

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.

Oracle Database

OracleOracle 10gOracle 8i
or Oracle,
A data dictionary consists of a special collection of tables that contains information about all user-objects in the database.

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

multisetsbagmultiset coefficient
"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 ServerInformix Corporation
External tables (in Informix

Tuple

5-tuplen''-tupletuples
For instance, a SQL table can potentially contain duplicate rows, whereas a true relation cannot contain duplicate 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 databasehierarchical modelhierarchical
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.