Mega Code Archive
Pattern based constraint
<![CDATA[
5> CREATE TABLE Customers
6> (
7> CustomerNo int IDENTITY NOT NULL
8> PRIMARY KEY,
9> CustomerName varchar(30) NOT NULL,
10> Address1 varchar(30) NOT NULL,
11> Address2 varchar(30) NOT NULL,
12> City varchar(20) NOT NULL,
13> State char(2) NOT NULL,
14> Zip varchar(10) NOT NULL,
15> Contact varchar(25) NOT NULL,
16> Phone char(15) NOT NULL,
17> FedIDNo varchar(9) NOT NULL,
18> DateInSystem smalldatetime NOT NULL
19> )
20> GO
1> ALTER TABLE Customers
2> WITH NOCHECK
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>
3> ALTER TABLE Customers
4> CHECK
5> CONSTRAINT CN_CustomerPhoneNo
6>
7> GO
1>
2> drop table Customers;
3> GO
1>
2>
3>
]]>