How to Get the Primary Key and foreign Key between two tables

Posted on July 28, 2011 by randheerparmar
These are the few tables which can be used to check the foreign key and primary key column in a table.
It will give both columns from both tables.
INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS  
INFORMATION_SCHEMA.TABLE_CONSTRAINTS
INFORMATION_SCHEMA.KEY_COLUMN_USAGE

About randheerparmar

Software engineer fond of traveling, food cricket and sleeping
This entry was posted in SQL Server Interview Questions and Answers. Bookmark the permalink.

1 Response to How to Get the Primary Key and foreign Key between two tables

  1. YSSS says:
    April 27, 2012 at 9:14 am

    Can you please give the example more detailed level please..!!

    Reply

Leave a comment