3rd highest salary in sql server

SQL Server find foreign key constraints references


SELECT *
            FROM sys.foreign_keys
            WHERE referenced_object_id = object_id('User')
           
n  OR

EXEC sp_fkeys 'User'

n  OR

SELECT  OBJECT_NAME(parent_object_id) AS Parent_Object,
                        OBJECT_NAME(referenced_object_id) AS Rreferenced_Object,
                        name
            FROM sys.foreign_keys

WHERE parent_object_id = object_id('User')


ANIL SINGH

Anil Singh is an author, tech blogger, and software programmer. Book writing, tech blogging is something do extra and Anil love doing it. For more detail, kindly refer to this link..

My Tech Blog - https://www.code-sample.com/
My Books - Book 1 and Book 2

SQL Server find foreign key constraints references SQL Server find foreign key constraints references Reviewed by Anil Singh on 12:07 AM Rating: (5)
www.code-sample.com/. Powered by Blogger.
^