Database Tables, Rows, and Columns Explained

SQL Tutorials

Database tables, rows, and columns are the basic building blocks of any database. If you understand these three ideas, working with SQL becomes much easier. Let’s break them down using simple examples.

What Is a Database Table

Each row represents one record, such as a single student.
Each column represents a field, such as student name or age.

Along with tables, databases also use a schema.
A schema is the structure or blueprint of the database. It defines how tables are organized and how data is stored.

The schema includes:

Table names
Column names
Data types
Relationships between tables

For example, the schema defines that the age column stores numbers and the name column stores text.

Because of the schema, the database stays consistent and organized. It also helps prevent invalid data from being stored.

What Are Columns in a Database

Columns define the type of data stored in a table.

Each column has a name and stores one kind of information. For example:

student_id
name
email
age

Every value in a column belongs to the same category.

What Are Rows in a Database

Rows store the actual data inside the table.

Each row represents one complete record. For example, one row can store all details of a single student.

If a table has ten students, it will have ten rows.

Simple Example of Table, Row, and Column

student_id	name	Email	age
1	Rahul	rahul@gmail.com	20
2	Ananya	anaya@gmail.com	21
3	Rishi	rishi@gmail.com	22

The table stores student data
Each column stores a specific type of data
Each row stores one student record

Easy Way to Remember

Table → The full sheet of data
Column → One type of information
Row → One complete record

Summary

Database tables, rows, and columns help organize data in a structured way. Tables store data, columns define the data type, and rows hold individual records. Once you understand this structure, learning SQL queries becomes much easier.