a quick way to reindex ?

[babeo]

Hi

I have a table having a field indexed with non-clustered, now I want to reindex the field as unique and clustered. Should I just drop the index first and recreate it or what is the best way to reindex it without dropping at the 1st place?.

There are a few tables related to this table through this index field (may be I am not talking properly: index or constrainst, but they related through this field), and I don't know any impact if I am dropping this index and causes any problem?

Please post a full command too.

Thanks.

 

[dickiebird]

No problem - other tables, constraints etc will still be valid when you drop your index.
Just do :
drop index myindex
go
CREATE UNIQUE CLUSTERED INDEX myindex
ON mydbowner.mytable(mycol1...)
go

HTH
;-) Dickie Bird
db@dickiebird.freeserve.co.uk

 

[JMCraig]

Just FYI, you can rebuild an index and then drop the existing one (as long as that wouldn't result in having two clustered indexes on the same table and you keep the indexes' names unique).

BOL,

JMC J M Craig
Alpha-G Consulting, LLC

http://alphagconsulting.bizhosting.com

nsjmcraig@netscape.net

 

[babeo]

Thanks all.
That's secured me enough.