MySQL数据库约束列表 [英] List of Constraints from MySQL Database

问题描述

如何从特定数据库中获取所有约束的列表？

How do I get a list of all constraints from a particular database?

推荐答案

使用 information_schema.table_constraints 表以获取每个表上定义的约束的名称：

Use the information_schema.table_constraints table to get the names of the constraints defined on each table:

select *
from information_schema.table_constraints
where constraint_schema = 'YOUR_DB'

使用 information_schema.key_column_usage 表格得到每个限制条件中的字段：

Use the information_schema.key_column_usage table to get the fields in each one of those constraints:

select *
from information_schema.key_column_usage
where constraint_schema = 'YOUR_DB'

如果您正在谈论外键限制，请使用 information_schema.referential_constraints ：

If instead you are talking about foreign key constraints, use information_schema.referential_constraints:

select *
from information_schema.referential_constraints
where constraint_schema = 'YOUR_DB'

这篇关于MySQL数据库约束列表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！