* Note: Do not populate the Customer2
table. This table will be populated in lesson eight.
* Note: In some cases you may
have to set your primary key in the Create Table scripts
using the following method: CustomerID INTEGER NOT NULL CONSTRAINT
PriKey Primary Key,
* Note: In Microsoft Access, when you do
not state NOT NULL when creating a column the column is automatically
set to NULL. In some DBMS's however, if you want to set a column
to NULL you must explicitly state NULL.
Note: In some versions of Microsoft Access you may have to set your primary key in the Create Table script using the following method: CustomerID INTEGER NOT NULL CONSTRAINT PriKey Primary Key,
CREATE TABLE Customer2
CustomerID INTEGER Primary Key NOT NULL,
FirstName CHAR(50) NOT NULL,
LastName CHAR(50) NOT NULL,