Mega Code Archive
NONCLUSTERED PRIMARY KEY
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