sp_helpindex:
index_name index_description
_dta_index_NAMES_6_1110295015__K1_K4_2nonclustered located on PRIMARY
_dta_index_NAMES_8_1110295015__K1_2nonclustered, hypothetical located on PRIMARY
_dta_index_NAMES_8_1110295015__K1_6nonclustered, hypothetical located on PRIMARY
_dta_index_NAMES_8_1110295015__K1_K2nonclustered, hypothetical located on PRIMARY
_dta_index_NAMES_8_1110295015__K1_K2_3_4_5_6_7nonclustered, hypothetical located on PRIMARY
_dta_index_NAMES_8_1110295015__K1_K3nonclustered, hypothetical located on PRIMARY
_dta_index_NAMES_8_1110295015__K1_K4nonclustered, hypothetical located on PRIMARY
_dta_index_NAMES_8_1110295015__K2_1nonclustered, hypothetical located on PRIMARY
_dta_index_NAMES_8_1110295015__K2_1_3_4_5_6_7nonclustered, hypothetical located on PRIMARY
_dta_index_NAMES_8_1110295015__K2_K1nonclustered, hypothetical located on PRIMARY
_dta_index_NAMES_8_1110295015__K2_K1_3_4_5_6_7nonclustered, hypothetical located on PRIMARY
_dta_index_NAMES_8_1110295015__K3_K1nonclustered, hypothetical located on PRIMARY
_dta_index_NAMES_8_1110295015__K4nonclustered, hypothetical located on PRIMARY
_dta_index_NAMES_8_1110295015__K4_K1nonclustered, hypothetical located on PRIMARY
_dta_index_NAMES_8_1110295015__K4_K1_2nonclustered, hypothetical located on PRIMARY
_dta_index_NAMES_8_1110295015__K5nonclustered, hypothetical located on PRIMARY
_dta_index_NAMES_8_1110295015__K5_K1nonclustered, hypothetical located on PRIMARY
_dta_index_NAMES_8_1110295015__K5_K2nonclustered, hypothetical located on PRIMARY
_dta_index_NAMES_c_8_1110295015__K1nonclustered, hypothetical located on PRIMARY
_dta_index_NAMES_c_8_1110295015__K1_K2nonclustered, hypothetical located on PRIMARY
_dta_index_NAMES_c_8_1110295015__K1_K4nonclustered, hypothetical located on PRIMARY
_dta_index_NAMES_c_8_1110295015__K2nonclustered, hypothetical located on PRIMARY
_dta_index_NAMES_c_8_1110295015__K2_K1nonclustered, hypothetical located on PRIMARY
_dta_index_NAMES_c_8_1110295015__K3nonclustered, hypothetical located on PRIMARY
_dta_index_NAMES_c_8_1110295015__K4nonclustered, hypothetical located on PRIMARY
_dta_index_NAMES_c_8_1110295015__K4_K1nonclustered, hypothetical located on PRIMARY
CIX_NAMES_NAMEIDclustered, unique located on PRIMARY
PK__NAMES__NAMEIDnonclustered, unique, primary key located on PRIMARY
error:
Msg 3723, Level 16, State 6, Line 3
An explicit DROP INDEX is not allowed on index 'dbo.NAMES.CIX_NAMES_NAMEID'. It is being used for FOREIGN KEY constraint enforcement.
Thanks,
Nate