Get All Tables Referenced by at Least One View
The following query will produce a list of tables that are referenced by one or more Views: SELECT [table] = s.name + N’.’ + t.name FROM sys.tables AS t INNER
The following query will produce a list of tables that are referenced by one or more Views: SELECT [table] = s.name + N’.’ + t.name FROM sys.tables AS t INNER