查看外键状态

查看外键是否开启的sql：

select a.table_name as "表名",a.constraint_name as "约束名",b.constatus as “是否启用” from information_schema.table_constraints a, sys_constraint b where a.constraint_name= b.conname and a.table_name = 't2' ;

select a.table_name as "表名",a.constraint_name as "约束名",b.constatus as “是否启用”,b.convalidated as "启动是否验证" from information_schema.table_constraints a, sys_constraint b where a.constraint_name= b.conname and a.table_name = 't2' ;