About Database Tables
Database tables will most likely be the area you'll become most familiar with after working with databases for a while. Now, before we go ahead and start adding tables to our new database, let's have a look at what a database table actually is.
What is a Table?
In database terms, a table is responsible for storing data in the database. Database tables consist of rows and columns.
In the following example, the second row is highlighted in black:
In the next example, the second column is highlighted in black. This column has been given a name of "FirstName":
A row contains each record in the table, and the column is responsible for defining the type of data that goes into each cell. Therefore, if we need to add a new person to our table, we would create a new row with the person's details.
OK, now lets go ahead and create a table.
- Creating a Database
- Creating Database Tables