title: Determine table referenced in a view in SQL Server
body: <p>How can i get to know the tables used in a view in SQL Server? Is there a script or a tool that could let me know the tables used in a view and can also list down the fields?</p>
  
  <p>Hope this clears the question. Let me know if not.</p>
  
  <p>Please guide! Thanks!</p>