7> CREATE TABLE Customers
8> (
9> CustomerNo int IDENTITY NOT NULL
10> PRIMARY KEY,
11> CustomerName varchar(30) NOT NULL,
12> Address1 varchar(30) NOT NULL,
13> Address2 varchar(30) NOT NULL,
14> City varchar(20) NOT NULL,
15> State char(2) NOT NULL,
16> Zip varchar(10) NOT NULL,
17> Contact varchar(25) NOT NULL,
18> Phone char(15) NOT NULL,
19> FedIDNo varchar(9) NOT NULL,
20> DateInSystem smalldatetime NOT NULL
21> )
22> GO
1>
2> ALTER TABLE Customers
3> ADD CONSTRAINT CN_CustomerAddress
4> DEFAULT 'UNKNOWN' FOR Address1
5> GO
1>
2> drop table Customers;
3> GO
1>
2>