Posted by serge on 06/18/05 16:01

> > 3- If i open the table in DESIGN view in SQL EM, i don't see
> > the Primary key icon. Yet here i see the words "PRIMARY KEY
> > NONCLUSTERED". Does this mean UNIQUENO is actually some type
> > of primary key?
>
> So this table apparently has a primary key, it is just the that the
> Table Designer in EM fails to recongnize it. I might be that it
> gets tricked by the fact that there is both a clustered and a non-
> clustered index on UNIQUENO, and the primary-key index is non-clustered.

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


Thanks for all the info. I will use the SQL Profiler to get 1 day of
workload
and then run the Index Tuning Wizard on this table and other tables.

• Next in forum: Newbie Can't connect - Trusted Server issue.
• Prev in forum: Re: Secure/selective data access
• Thread view: Re: What happens if a table has no Primary Key?

[Reply to this message]