title: SQL query to list all dependent entities
body: <p>An SQL table has hundreds of tables, stored procedures and functions. </p>
  
  <p>I am trying to put together an SQL query that will return all the dependencies of a given set of tables. Is there a way to accomplish this using <a href="http://SQL_Server_Management_Studio" rel="nofollow noreferrer">SQL Server Management Studio</a> without writing queries?</p>
  
  <p>Updated: Simplified the question to the point.</p>