Exercise

A - Create A table creation sql statement to create a table holding the information below
B - Create an initial INSERT statement that will place one row of information into the table.
C - Create an index on the ZIP-Code

Data

Name:     Caitlin Brennan
Address:  1604 N. West Street
          Suite 304-D
          Santa Clara, CA 99834-1223
Phone:    (444) 515-1212

Assume that the CustomerID column will be automatically created by the database engine (it's an automatically incrementing column).
Back to Main Database Page.