phone icon 781.329.4300  ¦  Message us  ¦ Customer support login ¦ Product documentation

  1. You are here:  
  2. Home
  3. DR Network
  4. TSQL code
  5. Search DR Metadata by Name

Welcome to the DR Network.

The DR Network has everything you need to get started building reports with Data Repository, including T-SQL stored procedures and functions, SSRS report definition files, and even Report Designer reports. Everything is free to the MT community and available for every MT version from MAGIC to Expanse. Sign up today!
Contact us
500 characters left

Search DR Metadata by Name

TSQL code
  • MT platform: All

Use this this stored procedure when you're not sure where to find data from a particular DR table or column. It searches for DR table or column names and returns relevant metadata from the DrTable_Main and DrTable_Columns (M-AT) or DrTableMain and DrTableColumns (MAGIC, C/S) tables.  (For more information on searching for metadata and data storage in MEDITECH, read this blog post.)

To download this report, please log in or create an account. → 

 

Sample output 

rpt search dr by name output

 

Code sample

 

rpt search dr by name