Thanks for the replies.

I know you have to specifically script the indexes from EM, it's not that.

I'm just wondering how the indexes could become divorced from the tables.

Renaming the table (using sp_rename) doesn't do it.

Dropping the table seems to remove the entry in sysindexes cleanly.

@tosscrosby, if you had that script it'd be very handy for me ?