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?

 


You might be using Adblocker. Since w3resource does not charge anything from users, all of our expenses (e.g. Hosting, Content Creation, Development etc.) are met by advertisement. Please whitelist w3resource.