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