How to find the parent table name & its primary key column from foreign key constraint name.
This is the name of my foreign key constraint "FK_ChildTableName_ChildTableColumnName" i.e. FK_Dept_EmpNum
From this how I find the parent table name and its primary key column name on which I create this relation.
I am using MS SQL 2005.
1)Emp (Parent Table)
EmpId int Primary Key
2) Dept (Child Table)
DeptNo int Not Null,
EmpNum int References Emp(EmpId)
View Complete Post