But I cannot use drop existing with referential constraints in place. I was
wondering if there is a way to create the index but without all the problems
of having to re-create 20+ constraints referring to other tables.
"Anith Sen" <anithbizdatasolutions.com> wrote in message
news:uv$maK8RDHA.3132tk2msftngp13.phx.gbl...if> You can use CREATE INDEX with DROP_EXISTING option to create a new indexyou> there is already one in place. Since you are building a clustered index,> will have to rebuild any other existing non-clustered indexes on the table
> again. Refer to SQL Server Books Online for more details.
> - Anith
> ( Please reply to newsgroups only )