ALERT

[LAST CHANCE] Data Layer: Modern Business, Defined

Table

Definition - What does Table mean?

A table is a named relational database data set that is organized by rows and columns. The relational table is a fundamental relational database concept because tables are the primary form of data storage.

Columns form the table’s structure, and rows form the content. Tables allow restrictions for columns (i.e., allowed column data type) but not rows. Every database table must have a unique name. Most relational databases have naming restrictions For example, the name may not contain spaces or be a reserved keyword such as TABLE or SYSTEM.

Techopedia explains Table

Relational tables store data in columns and rows. When creating a table, columns must be defined, but columns may be added or deleted after table creation. During this time, column data restrictions may or may not be defined. For example, when creating a CUSTOMER_MASTER table for storing customer information, definitions may be added, e.g., a DATE_OF_BIRTH column accepting dates only or a CUSTOMER_NAME column that may not be null (blank).

Table rows are the table’s actual data elements. In the CUSTOMER_MASTER table, the rows hold each customer record. Thus, a row consists of a data element within each table column. If a row value is not entered, the value is termed “null,” which does not have the same meaning as a zero or space.

Tables also have other table relationships that are defined by special columns, and the most prominent are primary and foreign keys. For example, the CUSTOMER_MASTER table has a CUSTOMER_ID column that is used to uniquely identify each table customer. If another table needs to refer to a certain customer, a corresponding column (also known as a foreign key) that references the CUSTOMER_MASTER table’s customer id may be inserted. Other tables do not need to store additional customer details that are already stored in the CUSTOMER_MASTER table.

Techopedia Deals

Connect with us

Techopedia on Linkedin
Techopedia on Linkedin
Tweat cdn.techopedia.com
"Techopedia" on Twitter


'@Techopedia'
Sign up for Techopedia's Free Newsletter!

Email Newsletter

Join thousands of others with our weekly newsletter

Resources
The 4th Era of IT Infrastructure: Superconverged Systems
The 4th Era of IT Infrastructure: Superconverged Systems:
Learn the benefits and limitations of the 3 generations of IT infrastructure – siloed, converged and hyperconverged – and discover how the 4th...
Approaches and Benefits of Network Virtualization
Approaches and Benefits of Network Virtualization:
Businesses today aspire to achieve a software-defined datacenter (SDDC) to enhance business agility and reduce operational complexity. However, the...
Free E-Book: Public Cloud Guide
Free E-Book: Public Cloud Guide:
This white paper is for leaders of Operations, Engineering, or Infrastructure teams who are creating or executing an IT roadmap.
Free Tool: Virtual Health Monitor
Free Tool: Virtual Health Monitor:
Virtual Health Monitor is a free virtualization monitoring and reporting tool for VMware, Hyper-V, RHEV, and XenServer environments.
Free 30 Day Trial – Turbonomic
Free 30 Day Trial – Turbonomic:
Turbonomic delivers an autonomic platform where virtual and cloud environments self-manage in real-time to assure application performance.