从 MySQL 数据库获取约束列表?

2023年 8月 30日 87.4k 0

从 MySQL 数据库获取约束列表?

要从 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 数据库获取约束列表?的详细内容,更多请关注每日运维网(www.mryunwei.com)其它相关文章!

相关文章

Oracle如何使用授予和撤销权限的语法和示例
Awesome Project: 探索 MatrixOrigin 云原生分布式数据库
下载丨66页PDF,云和恩墨技术通讯(2024年7月刊)
社区版oceanbase安装
Oracle 导出CSV工具-sqluldr2
ETL数据集成丨快速将MySQL数据迁移至Doris数据库

发布评论