5> CREATE TABLE MyTable (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 (MyID))
9> GO
1>
2>
3> drop table MyTable;
4> GO