A table is used to store data in a structured format using rows and columns. It is one of the most important parts of a database.
1. What is a Table?
A table organizes data into rows and columns so that it can be easily stored, accessed, and managed.
- Row: Represents one record
- Column: Represents one field
2. Real-World Example
Think of a student table:
- Each row = one student
- Each column = student information
3. Example Table
| ID | Name | Age |
|---|---|---|
| 1 | Ravi | 21 |
| 2 | Anu | 22 |
4. Key Points
- Tables store data in a structured format
- Each row represents a record
- Each column represents a field
- Tables make data easy to understand and manage
Conclusion
Tables are the basic building blocks used to organize and store data in a database.
Your learning journey continues 🚀
Tags
MS SQL Server
