Charles,
Try the following link on an artical about retreiving the database METADATA: https://dzone.com/articles/retrieving-table-metadata-from-sql-server-catalog 
The artical explains with SQL Scripts to pull...

To shrink it properly, so that it does not grow out of control. Create a Full backup of temp, then create a transaction backup say every 30 minutes with truncate....