Why it is required?
The main purpose of this is finding related constraint table from database.
Check below Query.
–get table list with constraint(primary and foreign key)
select * from information_schema.constraint_column_usage
–get table list with foreign key constraint
select * from information_schema.referential_constraints
–get the relation
select
tblAll.table_name as PrimaryTableName,
tblAll.column_name as PrimaryTableColumn,
tblFK.table_name as ForeignKeyTable,
tblFK.column_name as ForeignKeyColumn
from information_schema.constraint_column_usage tblAll
inner join information_schema.referential_constraints tblAllFK on tblAllFK.unique_constraint_name = tblAll.constraint_name
inner join information_schema.constraint_column_usage tblFK on tblAllFK.constraint_name=tblFK.constraint_name
Thnx
Leave a reply to nzc.gnt Cancel reply