Bits And Pix » MySQL: Force Drop Table with Foreign Keys

MySQL: Force Drop Table with Foreign Keys

June 6th, 2009 by jeremychone

If you try to drop a table that has some foreign keys, you will get an exception.

mysql> SET foreign_key_checks = 0;
mysql> drop table ...
mysql> SET foreign_key_checks = 1;

Posted: Saturday, June 6th, 2009
Tags: Mysql.
Actions: RSS 2.0 feed. You can leave a response, or trackback from your own site.

Leave a Reply

About:

Micro blogs about code, design, and sys-admin stuff. If you want to be an author as well, email Jeremy Chone
Authors
- Jeremy Chone
Blogroll
Categories
- Apache (8)
- Application Server (2)
- AspectJ (2)
- Chrome (1)
- CSS (6)
- Eclipse (5)
- Flash (1)
- Font (1)
- force.com (1)
- Freemarker (2)
- Git (7)
- Google (2)
- Groovy (1)
- GWT (2)
- Hibernate (13)
- Html (11)
- iBatis (2)
- iOs (1)
- Java (27)
- JavaScript (7)
- Jetty (2)
- jQuery (39)
- Linux (15)
- Maven (2)
- Mobile (1)
- Mysql (14)
- OpenWeb (7)
- OSX (7)
- Photoshop (6)
- php (2)
- Pics (11)
- Postgresql (3)
- RaphaelJs (1)
- RegEx (4)
- Spring (4)
- Sql (3)
- Subversion (4)
- Tech (1)
- Tomcat (5)
- Uncategorized (8)
- Video (2)
- web2.0 (4)
- Windows (3)
- Wordpress (4)
- XCode (1)
- XML (1)
- YouTube (2)