Databases and Tables


Every Relational Database management System or simply RDBMS consists of different types of database objects, the most important of the being the database table. Tables are database objects which store data. Each table has its own unique name, within a database. Database tables are exactly that tables they have columns and rows. Each table column has unique name (unique for a particular table) and each column defines what type of data it stores. The rows of the table are the actual data stored in the table, and are often called database records and database rows.

Here is how a SQL database table called Countries looks like:

Country Continent Capital Population
USA North America Washington 298,444,215
Canada North America Ottawa 33,098,932
Mexico North America Mexico 107,449,525
UK Europe London 60,609,153
Italy Europe Rome 58,133,509

The 4 columns of the table are Country, Continent, Capital and Population. This table has 5 rows for USA, Canada, Mexico, UK and Italy.