Table dependencies

• saravanakumar.G

  SSC Eights!

  Points: 817

  More actions

  September 3, 2013 at 12:01 am

  #277637

  Hi,

  I want to get the list of dependency tables(through all the levels ie child of child) that are depends on the parent table using T-SQL.

• HanShi

  SSC-Dedicated

  Points: 33508

  More actions

  September 3, 2013 at 2:14 am

  #1646900

  Take a look at the following article: http://technet.microsoft.com/en-us/library/ms345449(v=sql.105).aspx

  Keep in mind that it's possible the reported dependencies are NOT up-to-date. Some objects can be created when the depending object(s) does not exist yet. These dependencies won't be recorded.

  ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

• maneeshkrverma

  SSC Veteran

  Points: 224

  More actions

  September 4, 2013 at 2:33 am

  #1647211

  select OBJECT_NAME(OBJECT_ID) as procName,* from sys.sql_modules where definition like '%<tablename>%'

• Francis Apel

  SSC Eights!

  Points: 918

  More actions

  September 4, 2013 at 9:19 am

  #1647371

  SELECT referencing_schema_name, referencing_entity_name,

  referencing_id, referencing_class_desc, is_caller_dependent

  FROM sys.dm_sql_referencing_entities ('YourObject', 'OBJECT');

  If you want a recursive lookup, check out this:

  http://beyondrelational.com/modules/2/blogs/28/posts/10399/tsql-lab-9-how-to-find-the-dependency-chain-of-a-database-object.aspx

  Francis
  -----------------
  SQLRanger.com