Components of a table (of a database)
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 are pictorial presentation of a table and different components of it :

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

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

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

All the columns in a table make a row. Each row contains all the information of individual topics.

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

Each table should contain a field which can create a link with another one or more table is the key field of a table.
Check out our 1000+ SQL Exercises with solution and explanation to improve your skills.
Previous: Codd's 12-Rule Relational Database Definition
Next: Create/Alter/Drop Schema
SQL: Tips of the Day
Is SQL syntax case sensitive?
The SQL Keywords are case-insensitive (SELECT, FROM, WHERE, etc), but are often written in all caps. However in some setups table and column names are case-sensitive. MySQL has a configuration option to enable/disable it. Usually case-sensitive table and column names are the default on Linux MySQL and case-insensitive used to be the default on Windows, but now the installer asked about this during setup. For MSSQL it is a function of the database's collation setting.
Ref: https://bit.ly/3R2iyNZ
- Weekly Trends
- Python Interview Questions and Answers: Comprehensive Guide
- Scala Exercises, Practice, Solution
- Kotlin Exercises practice with solution
- MongoDB Exercises, Practice, Solution
- SQL Exercises, Practice, Solution - JOINS
- Java Basic Programming Exercises
- SQL Subqueries
- Adventureworks Database Exercises
- C# Sharp Basic Exercises
- SQL COUNT() with distinct
- JavaScript String Exercises
- JavaScript HTML Form Validation
- Java Collection Exercises
- SQL COUNT() function
- SQL Inner Join
We are closing our Disqus commenting system for some maintenanace issues. You may write to us at reach[at]yahoo[dot]com or visit us at Facebook