Re: Question: cleaning up PK indexes

From: IANAL_VISTA <IANAL_Vista_at_hotmail.com>
Date: Sat, 30 Apr 2005 00:29:03 GMT
Message-ID: <Xns9647B1DC0E8F4SunnySD@68.6.19.6>

"DW" <dwhittier_at_shaw.ca> wrote in
news:1114809302.334966.6310_at_f14g2000cwb.googlegroups.com:

> Hi, all.
>
> I've been tasked with doing some index cleanup, and am looking for a
> way to quantify my task.
>
> My db has about 450 tables in it. In some of these tables, the PK index
> is actually a UNIQUE INDEX PK_TBLNAME, rather than a CONSTRAINT
> PK_TBLNAME PRIMARY KEY.
>
> These still work, but they're not correct.
>

In what way are they "not correct"? Received on Fri Apr 29 2005 - 19:29:03 CDT