Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR SQL

See Foreign Key

SELECT
    TABLE_NAME,
    COLUMN_NAME,
    CONSTRAINT_NAME,
    REFERENCED_TABLE_NAME,
    REFERENCED_COLUMN_NAME
FROM
    INFORMATION_SCHEMA.KEY_COLUMN_USAGE
WHERE
	REFERENCED_TABLE_SCHEMA = 'db_name'
    AND REFERENCED_TABLE_NAME = 'table_name';
Source by tableplus.com #
 
PREVIOUS NEXT
Tagged: #See #Foreign #Key
ADD COMMENT
Topic
Name
4+7 =