MySQL 데이터베이스에서 제약 조건 목록을 얻으려면 다음 구문을 사용하십시오 -
select *from information_schema.table_constraints where constraint_schema = 'yourDatabaseName';
여기에서는 데이터베이스 "비즈니스"에서 제약 조건을 가져옵니다. 다음은 "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)