要从 mysql 数据库获取约束列表，请使用以下语法 -
select *from information_schema.table_constraints where constraint_schema = 'yourdatabasename';
在这里，我们将从数据库“business”中获取约束。以下是列出数据库“business”中所有表的约束的查询 -
mysql> select * −> from information_schema.table_constraints −> where constraint_schema = 'business';
以下是显示所有约束的输出 -
+--------------------+-------------------+--------------------------+--------------+------------------------------+-----------------+| constraint_catalog | constraint_schema | constraint_name | table_schema | table_name | constraint_type |+--------------------+-------------------+--------------------------+--------------+------------------------------+-----------------+| def | business | primary | business | primarytable | primary key || def | business | primary | business | primarytable1 | primary key || def | business | primary | business | autoincrementtable | primary key || def | business | primary | business | demoauto | primary key || def | business | primary | business | autoincrement | primary key || def | business | primary | business | primarytabledemo | primary key || def | business | primary | business | sequencedemo | primary key || def | business | primary | business | updtable | primary key || def | business | primary | business | transcationdemo | primary key || def | business | primary | business | triggedemo | primary key || def | business | primary | business | usernameandpassworddemo | primary key || def | business | userid | business | usernameandpassworddemo | unique || def | business | primary | business | tblp | primary key || def | business | name | business | uniquedemo | unique || def | business | name | business | uniqueconstdemo | unique || def | business | primary | business | keydemo | primary key || def | business | primary | business | nextiddemo | primary key || def | business | primary | business | tablepri | primary key || def | business | constfk | business | tabledemo2 | unique || def | business | constfk | business | tabledemo3 | unique || def | business | primary | business | college | primary key || def | business | id | business | uniquedemo1 | unique || def | business | id | business | uniqueautoid | unique || def | business | primary | business | schemadatabasemethoddemo | primary key || def | business | primary | business | employeeinformation | primary key || def | business | name | business | addingunique | unique || def | business | primary | business | parentdemo | primary key || def | business | primary | business | lastinsertrecordiddemo | primary key || def | business | primary | business | demoindex | primary key || def | business | primary | business | compositeprimarykey | primary key || def | business | primary | business | addingautoincrement | primary key | | def | business | id | business | uniqueconstrainttable | unique || def | business | primary | business | mergedemo1 | primary key || def | business | primary | business | mergedemo2 | primary key || def | business | primary | business | foreigntable1 | primary key || def | business | primary | business | twoprimarykeytabledemo | primary key || def | business | primary | business | showconstraintsdemo | primary key || def | business | bookauthor | business | showconstraintsdemo | unique || def | business | primary | business | autoincrementtozero | primary key || def | business | primary | business | altertabletoaddautoincrement | primary key || def | business | primary | business | addingprimarykeydemo | primary key || def | business | primary | business | resetprimarykey | primary key || def | business | constfkpk | business | foreigntable | foreign key || def | business | fkconst | business | foreigntabledemo | foreign key || def | business | constfk | business | tblf | foreign key || def | business | studcollegeconst | business | studentenrollment | foreign key || def | business | constchild | business | childdemo | foreign key || def | business | primarytable1demo_ibfk_1 | business | primarytable1demo | foreign key |+--------------------+-------------------+--------------------------+--------------+------------------------------+-----------------+48 rows in set, 2 warnings (0.24 sec)
以上就是从 mysql 数据库获取约束列表？的详细内容。