I need to DROP all the indexes on my tables and rebuild them. I have 5 TABLES left with INDEXes that I am NOT able to DROP INDEXES. I get the following error:
Server: Msg 3723, Level 16, State 6, Line 1
An explicit DROP INDEX is not allowed on index 'Table_Name.Index_Name'. It is being used for FOREIGN KEY constraint enforcement.
When I do a sp_helpindex on the table, it tells me that the INDEX is "clustered, unique located on PRIMARY"
Thanks in advance for the quick response!