Is there a way to alter an index on a table without dropping it and
recreating it?
I have a table containing 4 columns
(col1, col2, col3, col4)
and an index that currently uses 3 of them (not the primary key)
idx = (col1, col2, col3)
I want to change the index to
idx = (col2, col3)
I need to
At 11:46 -0500 2001/12/17, Roger Karnouk wrote:
Is there a way to alter an index on a table without dropping it and
recreating it?
I don't think so.
See: http://www.mysql.com/doc/A/L/ALTER_TABLE.html
HTH,
/Rob
--
Robert Alexander ([EMAIL PROTECTED]) 416-823-6599
http://www.workmate.ca WWW