Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 12.0.0 » SQL Anywhere 12 - Introduction » Data management technologies » Relational database concepts

 

Database tables

In a relational database, all data is held in tables, which are made up of rows and columns.

A database containing several tables.

Each table has one or more columns, and each column is assigned a specific data type, such as an integer, a sequence of characters (for text), or a date. Each row in the table has a single value for each column.

For example, a table containing employee information can look like the following:

EmployeeID Surname GivenName Phone
102 Huong Zhang 1096
10693 Donaldson Anne 7821
 Characteristics of relational tables
 What do you keep in each table?