w3resource logo

Components of a table

Components of a table (of a database)

Secondary Nav

SQL Tables

A table is a collection of rows having one or more columns. A row is an instance of a row type. Every row of the same table has the same row type. The value of the n-th field of every row in a table is the value of the n-th column of that row in the table. The row is the smallest unit of data that can be inserted into a table and deleted from a table.
The number of rows in a table is its cardinality. A table whose cardinality is 0 (zero) is said to be empty.

Following image is an pictorial presentation of a table and different components of it :

Components of a table

A column name can be used in more than one tables and to maintain integrity of data and reduce redundancy. This is called as relation.

Elements of a table

Components of a table - fields or columns

The information of a table stored against some heads, those are fields or columns. Columns shows vertically in a table.

Components of a table - column name

Each fields or column has an individual name. A table cannot contain same name of two different columns

Components of a table - record

All the columns in a table makes a row. Each row contain all the information of an individual topics.

Components of a table - column value

Value of each field makes a row is the column value.

Components of a table - key field

Each table should contain a field which can create a link with another one or more table is the key field of a table.

Is this content useful for you?