要从 MySQL 数据库获取约束列表，请使用以下语法 –
%ign%ignore_a_1%re_pre_1%在这里，我们将从数据库“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 数据库获取约束列表？的详细内容，更多请关注创想鸟其它相关文章！
版权声明：本文内容由互联网用户自发贡献，该文观点仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。
如发现本站有涉嫌抄袭侵权/违法违规的内容， 请发送邮件至 chuangxiangniao@163.com 举报，一经查实，本站将立刻删除。
发布者：程序猿，转转请注明出处：https://www.chuangxiangniao.com/p/114665.html
微信扫一扫 
支付宝扫一扫 
