question

to save us all a lot of time, where have you looked for this information already?

This table exits in Sql Server 2008 R2(SP2) report server database.

@sanjeev.matte This information was already available in your question and many of us already know. I beleive @Fatherjack was asking that have you find any other information anywhere? But AFAIK, Microsoft do recommend that the Report Server database schema should not be queried directly. Instead Reporting Services APIs should be used. This is where not much information is available for these tables as they could be changed/replaced in newer versions/ SPs.

Thanks for your time.

The tables in the ReportServer database should be queried with utmost care or better still not queried directly at all as Usman has already pointed out. The major table there is named **Catalog**, it has one record per existing report. The records in the **Catalog** table are uniquely identified by the column named **ItemID**. This column is referenced twice by the **ModelDrill** table. The latter has a column named **ModelID** which references the **ItemID** of the **Catalog** and it also has a column named **ReportID** which also references the **ItemID** of the **Catalog** table. Even though **ModelDrill** table has a primary key on the column named ModelDrillID which is of uniqueidentifier type, the table is clustered by 3 columns: ModelID, ReportID and then ModelDrillID, in this order. It looks like this table exists to simply map which sub-report to use when providing drill through functionality to existing parent report. There is not really much to know about it, and Microsoft is doing the right thing by not publishing the details about ReportServer tables design because they very much could change in newer versions anyway.