Need More Help Un-Doing Query

[Marco van Herwaarden]

Correct

[dieselpowered]

Hmmm says it cannot drop:

ALTER TABLE user DROP INDEX ratetradetotal;

Nevermind, looks like when I dropped the first one, it dropped the second?? Would it have done that?

[Colin F]

Originally Posted by xtremeoff-road

Hmmm says it cannot drop:

ALTER TABLE user DROP INDEX ratetradetotal;

Nevermind, looks like when I dropped the first one, it dropped the second?? Would it have done that?

I don't know MySQL that well, but I'd say that's possible, as it's an index on the table and doesn't make sense to keep that if the table itself isn't around anymore.

[Marco van Herwaarden]

Yes, the index is based on that column, so if you drop the column the index also get dropped.

[dieselpowered]

WOOHOO I am an SQL genious!!!

Thanks guys for taking the time to help...have a great one!