A license for erwin DM could not be obtained. The application will shut down. Error codes: 7(-96,491,0)
Cannot launch application after upgrade from 9.x to 9.7 - Error Codes: 7 (-1,359,2)
Query to generate Relationship Names, Parent and Child Table Names and PK and FK Column Names
Why Attribute order in Model Explorer is different than in Attribute Editor? How to match them?
What is the process to reactivate popup screen after it is disabled?
When trying to open any .erwin file by double clicking it, the erwin installation starts. Do you know why?
How can I change the default prefix that erwin assigns to the Primary Keys? By default it appears XPK and I need to change it to PK?
The task manager shows that erwin DM 9.8 is still running but there is no actual Window
Is erwin Data Modeler supported on a Macintosh or IOS?
When returning a License Code for erwin DM 2018 R1 , I received the error message, "You have exceeded the license's number of returns allowed. Please contact erwin Inc. Technical Support for further information."

See more

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

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

Permalink

Please sign in to leave a comment.

Powered by Zendesk