|
5>
6> CREATE TABLE MyTable (
7> MyID Int IDENTITY(1,1) NOT NULL , ID Int NOT NULL
8> , Description nVarChar(50)
9> , Region nVarChar(10) DEFAULT 'PNW'
10> , CONSTRAINT MyTable_PK PRIMARY KEY NONCLUSTERED (MyID,Region))
11> GO
1>
2> ALTER TABLE MyTable
3> ADD CONSTRAINT PK_ID PRIMARY KEY NONCLUSTERED (MyID)
4> GO
Msg 1779, Level 16, State 1, Server J\SQLEXPRESS, Line 2
Table 'MyTable' already has a primary key defined on it.
Msg 1750, Level 16, State 1, Server J\SQLEXPRESS, Line 2
Could not create constraint. See previous errors.
1>
2> drop table MyTable;
3> GO
1>
|