Jump to content

Archived

This topic is now archived and is closed to further replies.

richswww

RENAME TABLE and indexes

Recommended Posts

(Possibly) dumb question:

Let's say I have table foo with an index called myindex.

If I do "RENAME TABLE foo TO bar" ...

Will the "myindex" index be attached to the new table "bar", or should I drop the "myindex" index from the foo table and recreate it on the "bar" table after the rename?

Thanks,
Rich Stephens

Share this post


Link to post
Share on other sites
Renaming the table should have no effect on any indexes in said table, at least in MyISAM.

Share this post


Link to post
Share on other sites
So, by "no effect", you mean, the index should still be in place, so no need to drop and recreate them?

Rich S.

Share this post


Link to post
Share on other sites
That's correct... at least for MyISAM, the table name is simple the file name of the underlying data and index files, so they don't even "know" about the change.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.