What is Table?

• zendnwar
• September 14, 2012
• SQL
• 0 Comments

What is Table?

Tables are used to provide reference to comparative data when individual comparisons are not possible or preferable. In database terms, a table is responsible for storing data in the database. Database tables consist of rows and columns.

Each column contains a different type of attribute and each row corresponds to a single record. For example, imagine that we were building a database table that contained names and telephone numbers. We’d probably set up columns named “FirstName”, “LastName” and “TelephoneNumber.” Then we’d simply start adding rows underneath those columns that contained the data we’re planning to store.

Employee Table:

If we were building a table of contact information for our business that has 50 employees, we’d wind up with a table that contains 50 rows.