sql-serverreporting-servicesreportserver

Getting a list of all tables from the ReportServer Database

Is there any way to get a list of all the tables in ReportServer database? I used the dbo.catalog to get all the reports. But I need to find a way where I can see all the tables that are being used in all the reports.

Thanks in advance.

Solution 
  • Select * From [ReportServer$SS2014].INFORMATION_SCHEMA.Tables