SQL Tables & Data Types
1. What is a Table in SQL?
A table is like a spreadsheet where data is stored in rows and columns.
Columns: Define the type of data (like Name, Age, Email).
Rows: Contain the actual data entries.
Example Table: Students
| Column Name | Data Type | Example |
| ID | INT | 1 |
| Name | VARCHAR | 'Priyaa' |
| Age | INT | 20 |
| VARCHAR | 'priyaa@email.com' |
2. What are Data Types?
Data types tell SQL what kind of data can be stored in a column.
Example
| Data Type | Description | Example |
| INT | Whole numbers | 1, 25, 100 |
| VARCHAR | Text (string) | 'Priyaa' |
| DATE | Dates | '2026-01-26' |
| FLOAT | Decimal numbers | 10.5, 99.99 |
| BOOLEAN | True or False | TRUE, FALSE |