SQL Database Tables

<< Click to Display Table of Contents >>

Navigation:  Additional References > Database Primer >

SQL Database Tables

Previous pageReturn to chapter overviewNext page

 

A database most often contains one or more tables. Each table is identified by a name (e.g. "Persons" or "Accounts"). Tables contain records (rows) with data. Below is an example of a table named ‘Persons’

 

 

Last Name

First Name

Address

City

Smith

John

24 West Ave

Los Angeles

Wayman

Laurie

16 Davidson St

Los Angeles

Johnson

Paul

1243 Georgetown Dr

Los Angeles

 

 

The table above contains three records (one for each person) and four columns (LastName, FirstName, Address, and City).