5> CREATE TABLE MyTable (
6> MyID Int IDENTITY(1, 1) NOT NULL
7> ,MyDescription nVarChar(50) NOT NULL
8> ,Region nVarChar(10) NOT NULL
9> ,CONSTRAINT PK_ID PRIMARY KEY CLUSTERED (MyID))
10> go
1>
2>
3> ALTER TABLE MyTable WITH NOCHECK
4> ADD CONSTRAINT ckRegion CHECK
5> (REGION IN ('PNW','SW','MT','CENTRAL','EAST','SOUTH'))
6> GO
1>
2> drop table MyTable;