List sql table relations using query [duplicate]

Question

I have one Employee table in my Database which has relations to different other tables. In my application, When a user try to delete one employee which has relational data in other tables, I want to display a list of that tables to the user. Can I list all table names which prevents the Employee to be deleted (relational data Tables) using a query?

You can do with sys tables (check this stackoverflow.com/questions/8094156/… ), but in realtime that can be performance botteneck. I would suggest to return this list manually or let exception thrown having proper rollback mechanism. — Anil
– Anil, Commented May 7, 2015 at 6:40

TeamTam · Accepted Answer · 2015-05-07 06:42:45Z

2

Assuming there are foreign keys set up, you should be able to run this stored procedure.

EXEC sp_fkeys 'Employee'

answered May 7, 2015 at 6:42

TeamTam

1,60812 silver badges15 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

List sql table relations using query [duplicate]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related