Getting all ancestral parents of a table

Question

Post reply

Getting all ancestral parents of a table

jaango123

SSC Veteran

Points: 271
More actions
October 15, 2024 at 5:30 pm

#4468863
From this link - https://stackoverflow.com/questions/22005698/how-to-find-all-the-dependencies-of-a-table-in-sql-server
I can find all the child dependencies starting from my table(dbo first).
```
SELECT referencing_schema_name, referencing_entity_name,
referencing_id, referencing_class_desc, is_caller_dependent
FROM sys.dm_sql_referencing_entities ('dbo.First', 'OBJECT');
GO
```
Now i want the ancestral recursive parents of my table(starting from the raw source table/view)? How can i find it?

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Site Owners SSC Guru Points: 80325 More actions · Answer 1

Thanks for posting your issue and hopefully someone will answer soon.

This is an automated bump to increase visibility of your question.

Jeff Moden SSC Guru Points: 1004412 More actions · Answer 2

From the same SO link you provided, see the following link. Within that, look for an "It-Depends" header. The first paragraph of that section has to underlined n0t-so-obvious links that take you to the SQL code that should do it for you. I haven't personally tested the code but the author of the article is one of the people that I generally trust.

https://www.red-gate.com/simple-talk/databases/sql-server/t-sql-programming-sql-server/dependencies-and-references-in-sql-server/

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)