4> CREATE TABLE MyTable ( 5> MyID Int IDENTITY(1,1) NOT NULL 6> , Description nVarChar(50) NOT NULL 7> , Region nVarChar(10) NOT NULL DEFAULT 'PNW' 8> , CONSTRAINT PK_ID PRIMARY KEY NONCLUSTERED (MyID)) 9> GO 1> 2> 3> drop table MyTable; 4> GO