|
SQL Interpreter and Tutorial with Live Practice Database
|
|
Table Basics
A relational database system contains one or more objects called tables.
The data or information for the database are stored in these tables. Tables
are uniquely identified by their names and are comprised of columns and
rows. Columns contain the column name, data type, and any other attributes
for the column. Rows contain the records or data for the columns. Here is a
sample table called "weather".
city, state, high, and low are the columns. The rows contain the data for
this table:
| Weather |
| city |
state |
high |
low |
| Phoenix |
Arizona |
105 |
90 |
| Tucson |
Arizona |
101 |
92 |
| Flagstaff |
Arizona |
88 |
69 |
| San Diego |
California |
77 |
60 |
| Albuquerque |
New
Mexico |
80 |
72 |
|
|