MySQL查看一个表的所有外键,避免每个表都去查看。
select * from INFORMATION_SCHEMA.KEY_COLUMN_USAGE
where CONSTRAINT_SCHEMA ='database1'
MySQL查看一个表的所有外键,避免每个表都去查看。
select * from INFORMATION_SCHEMA.KEY_COLUMN_USAGE
where CONSTRAINT_SCHEMA ='database1'