To get all referrenced columns - Need TSQL script
If I pass table name and column name it should return all the Table names and columns where the given column is referred as FK. How to achieve this? Please do assist.
Ex: GetAllReference('Employee'
Should retun as given below
TABLE COLUMN
--------------------------
Dependent DependentEmpID
PolicyAsist EmpID.
Ex: GetAllReference('Employee'
Should retun as given below
TABLE COLUMN
--------------------------
Dependent DependentEmpID
PolicyAsist EmpID.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER