declare @tblList table(tblname varchar(222) null) insert into @tblList SELECT DBACTT_table_name FROM dbo.DBA_change_tracking_template ; select t.TABLE_SCHEMA, t.TABLE_NAME from INFORMATION_SCHEMA.TABLES t join @tblList s on s.tblname = t.TABLE_NAME order by TABLE_SCHEMA, TABLE_NAME