Is it possible to find all tables that has a join with 'tMyTable'

• TheSQLGuru

  SSC Guru

  Points: 134017

  More actions

  January 7, 2015 at 7:12 am

  #1768440

  This isn't 100% accurate, but it will get you close

  select object_name(object_id)

  from sys.sql_modules

  where definition like '%mytablename%'

  and definition like '%join%'

  Best,
  Kevin G. Boles
  SQL Server Consultant
  SQL MVP 2007-2012
  TheSQLGuru on googles mail service