mysql
SET FOREIGN_KEY_CHECKS = 0;
delete from approval_info;
delete from approval_manage;
delete from site_message;
delete from works;
delete from works_theme;
SET FOREIGN_KEY_CHECKS = 1;
oracle drop tablename no CONSTRAINT
还有一个本办法就是
一个一个的找到主键然后外键约束，然后执行，表或者数据的操作
原文：http://www.cnblogs.com/rocky-AGE-24/p/6753470.html