Start a conversation

Listing the tables in QES and their functional types

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

Choose files or drag and drop files
Was this article helpful?
Yes
No
  1. Jaydel Gluckie

  2. Posted
  3. Updated

Comments