Posted by Erland Sommarskog on 06/18/05 19:49

serge (sergea@nospam.ehmail.com) writes:
> No I am sorry I was wrong on this one. I just realized that I had manually
> put back the PK in the table designer.
>
> So this line did not exist before i altered the table:
>
> CONSTRAINT [PK_TBLTEST] PRIMARY KEY NONCLUSTERED
> (
> [UNIQUENO]
> ) ON [PRIMARY]
> GO

OK. Anyway, the table had a unique index on uniqueno, so it sounds
like the table had a primary key, although it was not declared so
formally. Who knows? Maybe a leftover from 4.x days when there were
no declared referential integrity at all.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

[Back to original message]