SQL to see the underlying table joins of a View

Question

Hi,&nbsp;I would like to see the underlying table joins that were used to create a view. &nbsp;Is this possible? &nbsp;Any suggestions? &nbsp;&nbsp;Kind regards,&nbsp;Julie Bunavicz

olafhelper · Answer

JulieBunavicz1600&nbsp;, sure it's possible and there are several methods.One: In SSMS right-mouse on the view =&gt; View dependenciesOthers:View the Dependencies of a Table - SQL Server | Microsoft Learnsp_depends (Transact-SQL) - SQL Server | Microsoft LearnView the Dependencies of a Stored Procedure - SQL Server | Microsoft Learn

Forum Discussion

SQL to see the underlying table joins of a View

1 Reply

Resources