Mega Code Archive
A unique constraint
<![CDATA[
5> CREATE TABLE MyTable (
6> MyID Int IDENTITY(1,1) NOT NULL , ID Int NOT NULL
7> , Description nVarChar(50)
8> , Region nVarChar(10) DEFAULT 'PNW'
9> , CONSTRAINT MyTable_PK PRIMARY KEY NONCLUSTERED (MyID,ID))
10> GO
1>
2> drop table MyTable;
3> GO
]]>