Forum Discussion

JulieBunavicz1600

Copper Contributor

Oct 30, 2023

SQL to see the underlying table joins of a View

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

Bronze Contributor

Nov 01, 2023

JulieBunavicz1600 , sure it's possible and there are several methods.

One: In SSMS right-mouse on the view => View dependencies

Others:

View the Dependencies of a Table - SQL Server | Microsoft Learn

sp_depends (Transact-SQL) - SQL Server | Microsoft Learn

View the Dependencies of a Stored Procedure - SQL Server | Microsoft Learn