Does dropping a table in MySQL also drop the indexes?

mysql database indexing sql-drop
Teflon Ted picture Teflon Ted · May 20, 2009 · Viewed 19.3k times · Source

It's not explicitly mentioned in the documentation (http://dev.mysql.com/doc/refman/6.0/en/drop-table.html). I ask because I just saw a curious database migration in a Rails project where the developer was removing all the indexes before dropping the table, and that seemed unnecessary.

Answer

AvatarKava picture AvatarKava · May 20, 2009

Yes, it does.

However, if you have foreign key constraints such as RESTRICT that ensure referential integrity with other tables, you'll want to drop those keys prior to dropping or truncating a table.

Related questions

Does MySQL index foreign key columns automatically?

Does MySQL index foreign key columns automatically?

Read More
Is the primary key automatically indexed in MySQL?

Do you need to explicitly create an index, or is it implicit when defining the primary key? Is the answer the same for MyISAM and InnoDB?

Read More
Two single-column indexes vs one two-column index in MySQL?

I'm faced with the following and I'm not sure what's best practice. Consider the following table (which will get large): id PK | giver_id FK | recipient_id FK | date I'm using InnoDB and from what I understand, it creates indices …

Read More