CA ERwin DM: query to return Table name, UDP name, and UDP values

Jun Lin

Updated April 19, 2018 08:12

Article ID: 2873

Last updated: 22 Aug, 2012

Title: CA ERwin DM: query to return Table name, UDP name, and UDP values.

Description:

Query to return Table name, UDP name, and UDP values.

Solution:

select    O.Name as "Table Name",
              PT.Name as "UDP name",
              tag_UDP_values_list as"UDP values"
from      Entity O, Property_type PT
where    PT.tag_is_locally_defined = 'T'

Comments

1 comment

Alejandra Silva August 03, 2017 21:05

Which would be an option in ERwin r9? Specify in ERwin 9.601?

Thank you!

:)

-1

Comment actions Permalink

Please sign in to leave a comment.

Articles in this section

Related articles