2. Overview of Tools and Languages : Terms and Concepts : Tables
 
Share this page                  
Tables
An Ingres table contains columns for each type of data and rows with all the information for each entry in the table. The following table shows data about customers:
Name
Address
City
Balance
Armand Karol
1000 Pine St.
San Francisco
$9,500
LaDette Watson
666 Rose Ave.
Berkeley
$1,250
Betsy Stark
33 Schuman Dr.
Castro Valley
$4,375
My Lin Truong
100 Sheila Ave.
Oakland
$5,500
Each item in the top row (for example, Name) is the title of a column. Each row under it provides information about one customer.
The user of an application usually needs to access one or more tables to look up information or manipulate the data (that is, add, delete, or change the data). A typical application displays table information and allows the user to choose the kind of data manipulation required.