-
-
Notifications
You must be signed in to change notification settings - Fork 563
Foreign key references. #1825
Copy link
Copy link
Closed
Labels
confirmedIssue verified by project memberIssue verified by project memberfeatureA new feature to implementA new feature to implement
Milestone
Description
Is your feature request related to a problem? Please describe.
I can't see which tabels refer to the current tabel with a foreign key.
Describe the solution you'd like
A new tab with a list of refferals to the current table.
Describe alternatives you've considered
I've used the following query to get what I need:
SELECT
TABLE_NAME,COLUMN_NAME,CONSTRAINT_NAME, REFERENCED_TABLE_NAME,REFERENCED_COLUMN_NAME
FROM
INFORMATION_SCHEMA.KEY_COLUMN_USAGE
WHERE
REFERENCED_TABLE_SCHEMA = '<database>' AND
REFERENCED_TABLE_NAME = '<table>';
But a push of a button would be easier.
Additional context
Reactions are currently unavailable
Metadata
Metadata
Assignees
Labels
confirmedIssue verified by project memberIssue verified by project memberfeatureA new feature to implementA new feature to implement