Answers for "mysql find db contarint"

SQL
0

mysql find db contarint

select *
from information_schema.key_column_usage
where constraint_name='[CONSTRAINT_NAME]'
Posted by: Guest on October-20-2020
-2

mysql show check constraints

select COLUMN_NAME, CONSTRAINT_NAME, REFERENCED_COLUMN_NAME, REFERENCED_TABLE_NAME
from information_schema.KEY_COLUMN_USAGE
where TABLE_NAME = 'users';
Posted by: Guest on October-05-2020

Code answers related to "SQL"

Browse Popular Code Answers by Language