达梦数据库查询数据库中所有的外键约束并关闭
SELECT ALL_CONS_COLUMNS.TABLE_NAME, ALL_CONS_COLUMNS.CONSTRAINT_NAME, ALL_CONS_COLUMNS.OWNERFROM SYSCONS, SYSOBJECTS, ALL_CONS_COLUMNS WHERE SYSCONS.id=SYSOBJECTS.id --'F'代表外键,'P'代表主键,'U'唯一索引AND SYSCONS.TYPE$='F' AND SYSOBJECTS.name=ALL_CONS_COLUMNS.C