|
5>
6>
7>
8> CREATE TABLE Customers
9> (
10> CustomerNo int IDENTITY NOT NULL
11> PRIMARY KEY,
12> CustomerName varchar(30) NOT NULL,
13> Address1 varchar(30) NOT NULL,
14> Address2 varchar(30) NOT NULL,
15> City varchar(20) NOT NULL,
16> State char(2) NOT NULL,
17> Zip varchar(10) NOT NULL,
18> Contact varchar(25) NOT NULL,
19> Phone char(15) NOT NULL,
20> FedIDNo varchar(9) NOT NULL,
21> DateInSystem smalldatetime NOT NULL
22> )
23> GO
1>
2> ALTER TABLE Customers
3> ADD CONSTRAINT CN_CustomerPhoneNo
4> CHECK
5> (Phone LIKE '([0-9][0-9][0-9]) [0-9][0-9][0-9]-[0-9][0-9][0-9][0-9]')
6> go
1>
2> drop table Customers;
3> GO
|