Convert unique clustered indexes to PK constraints

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

bpdee - 29 Feb 2008 22:14 GMT

Hi,

We have a database where no PK constraints are defined and only unique
clustered indexes. Is there a way for us to change all the columns that make
up the unique clustered index in all of the tables in the database to be the
columns that make up the PK constraint of the tables? In other words, we
want to change the clustered indexes to actual PK constraints.

Thanks,
Dee

Reply to this Message

jason - 01 Mar 2008 01:12 GMT

There is no easy way. You have to drop the CI and then run the alter table
commands. You could use the system catalogs to help generate the commands
though.

Signature

Jason Massie
www: http://statisticsio.com
rss: http://feeds.feedburner.com/statisticsio

> Hi,
>
[quoted text clipped - 8 lines]
> Thanks,
> Dee

Reply to this Message