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

还有一个本办法就是

一个一个的找到主键然后外键约束，然后执行，表或者数据的操作