Answers for "how to know which table to make foreign key"

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';

Posted by: Guest on August-28-2021

Source

Code answers related to "how to know which table to make foreign key"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Python

Javascript

Whatever

Shell/Bash

CSS

Html

PHP

SQL

Java

Answers for "how to know which table to make foreign key"

Code answers related to "how to know which table to make foreign key"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "how to know which table to make foreign key"

Code answers related to "how to know which table to make foreign key"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Popular Programming Languages

Advertisements

Company

Compilers

Help

Connect with us