Get All Tables Referenced by at Least One View September 7, 2017 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