What is a Database Table?
A database table is the fundamental building block of relational databases. It organizes data into rows and columns, where each row represents a record and each column represents a specific attribute of that record.
Key Characteristics:
- Tables store related data, such as customer information or product inventory.
- Columns define data types, like text, numbers, or dates.
- Rows contain actual data entries.
- Each table typically has a primary key to uniquely identify records.
Understanding tables is essential for working with SQL and managing structured data efficiently.