Run the following query in SQL Management Studio:

SELECT objtype, objname, name, value
FROM fn_listextendedproperty (NULL, 'schema', 'dbo', 'table', default, NULL, NULL)
WHERE name = 'Type' and
(value = 'TRX' OR
value = 'OPR' OR
value = 'SETUP' OR
value = 'MSTR')
order by objname


If you don't want all of the extended properties and columns you could run this query as well

SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE' and TABLE_NAME Like 'HQMS%'


Once you have the data in SSMS you can right click on the results in the upper left box and say "Copy with headers" and then paste into Excel or any application of your choice.