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

• Next in forum: Re: Running VB Function in SQL?
• Prev in forum: Re: Multiple insert
• Thread view: Re: What happens if a table has no Primary Key?

[Reply to this message]