Answers for "how to find a foreign key constraint to involve primary key sql"

how to check foreign key constraint in sql

sp_help 'TableName'

Posted by: Guest on May-26-2021

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

Code answers related to "how to find a foreign key constraint to involve primary key sql"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "how to find a foreign key constraint to involve primary key sql"

Code answers related to "how to find a foreign key constraint to involve primary key sql"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "how to find a foreign key constraint to involve primary key sql"

Code answers related to "how to find a foreign key constraint to involve primary key sql"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Popular Programming Languages

Advertisements

Company

Compilers

Help

Connect with us