sql server find all foreign keys that reference a column

SELECT 
   OBJECT_NAME(f.parent_object_id) TableName,
   COL_NAME(fc.parent_object_id,fc.parent_column_id) ColName
FROM 
   sys.foreign_keys AS f
INNER JOIN 
   sys.foreign_key_columns AS fc 
      ON f.OBJECT_ID = fc.constraint_object_id
INNER JOIN 
   sys.tables t 
      ON t.OBJECT_ID = fc.referenced_object_id
WHERE 
   OBJECT_NAME (f.referenced_object_id) = 'YourTableName'

View another examples Add Own solution

Log in, to leave a comment

3.8

5

Doug Kavendek 105 points

                                    EXEC sp_fkeys 'TableName'

Thank you! 5

3.8 (5 Votes)

0

Are there any code examples left?

Find Add Code snippet

New code examples in category SQL

SQL 2022-03-27 22:45:25 how to get mysql on ubuntu
SQL 2022-03-27 20:00:47 install latest mysql on debian 9
SQL 2022-03-27 19:45:11 sql '=' cannot be applied to date varchar(10) athena
SQL 2022-03-27 19:20:41 sql is not null
SQL 2022-03-27 19:20:39 sql group by error
SQL 2022-03-27 18:35:10 replace null with 0 in sql
SQL 2022-03-27 17:30:32 concat column value of same user in mysql
SQL 2022-03-27 17:05:02 sql developer sql worksheet not showing
SQL 2022-03-27 16:45:07 kill a pid redshift
SQL 2022-03-27 16:00:09 joins in sql server

Create a Free Account

Unlock the power of data and AI by diving into Python, ChatGPT, SQL, Power BI, and beyond.

Develop soft skills on BrainApps

Complete the IQ Test

Relative searches

get all foreign keys of a table sql server mssql get foreign keys columns see all foreign keys sql server sql see foreign keys of a column how to to get all foreign key column name and table name in sql find all foreign keys referencing a table in sql server sql find all foreign key references find all foreign keys in database sql server sql query to find foreign key references of a table sql find foreign key references sql server see what foreign keys reference column tsql find all foreign keys how to find the foreign key reference table in sql server sql server get column foreign key sql server find foreign key references by column how to find all foreign keys in sql server tsql find a foreign key by name check all foreign keys sql server sql list foreign key constraints for given column sql list all foreign key constraints for column sql show table show foreign key list foreign key constraints sql server get foreign key sql show foreignkeys sql server find table foreign key references show table foreign keys sqlserver how to get list of foreign keys in sql server sql view all foreign key find out which table foreign key orcale find out which table foreign key sql server how to know foreign key references for a table in sql server how to find table name from foreign key in sql server select all foreign key constraints sql server sql find all tables with foreign key like sql show the table of the foreign key sql server SELECT * FROM sys.foreign_keys; for one table sql server get fk only get table of foreign key sql sql server get table foreign keys sql server get table fk sql server get foreign key select foreign key sql server sql server find all foreign key references to a table sql show foreign keys get foreign key references table sql get information from a table with a foreign keys sql server find all foreign keys referencing a table list table foreign keys sql list of tables referencing another table sq;l server sql find all tables with foreign key sqlserver how to find out all foreign key references fing all refernced table to foreing key sql sql list all actions of foreign key mssql find foreign key references sql get foreign key list of all foreign key in sql sql server find all foreign keys pointing to my table sql server find all foreign keys pointing to my tablle check where key is referenced in all tables all the foreign keys in pcshop.sql sql server query all foreign tables sql server query all foreign keys relationships sql server query all foreign keys relationship sql server query all foreign keys find all tables with foreign key to table get all constraints dependent on certain table mssql sql get row and all foreign key references mssql query show table primary and foreign keys select all foreign keys sql server sql server how to find foreign key references sql foreign key list how to get foreign key in sql table how to get foreign key references in sql table how to get foreign key references in sql select foreign key sql get all foreign keys in sql server get table by foreign key sql find foreign key references for table how to show all references foreign key list of foreignkey references in sql database sql query foreign key like search find all foreign keys referencing a table sql server sql where foreign key in list sql find all foreign keys to a table sql get foregn key in query t-sql get foreign keys of table sql server fetch foreign key base and primary table sql select all where foreign key is in the list sql server get foreign key tables how to get the foreign keys of a table in sql sql server find all foreign keys that reference a column sql find all tables with foreign key to table tsql find foreign key references sql server show foreign keys for table sql server show foreign key constraints t-sql list fk SQL script to check if foriegn keys found in table sql get table foreign keys how to get foreign keys of a table in sql sql server query all foreking keys to specific table t-sql find all foreign key references mssql get foreign keys for table

Made with love

Welcome Back!

Sign up to unlock all of IQCode features:

Test your skills and track progress
Engage in comprehensive interactive courses
Commit to daily skill-enhancing challenges
Solve practical, real-world issues
Share your insights and learnings

Create an account

Create a Free Account

Sign up to unlock all of IQCode features:

Test your skills and track progress
Engage in comprehensive interactive courses
Commit to daily skill-enhancing challenges
Solve practical, real-world issues
Share your insights and learnings

Create an account

Creating a new code example