Sparx Systems Forum

Enterprise Architect => General Board => Topic started by: Richard Freggi on February 18, 2020, 12:54:32 pm

Title: What are the queries to show attribute constraints?
Post by: Richard Freggi on February 18, 2020, 12:54:32 pm

I'm creating a SQL query to show attribute constraints on a data model (PK/FK, null/not null, unique etc.), but I can;t find where they are stored in the model database.  Anyone knows which EA table/attribute holds them?  Maybe as tagged values somewhere?  Thanks!

Title: Re: What are the queries to show attribute constraints?
Post by: Geert Bellekens on February 18, 2020, 04:10:49 pm

Most of them are in t_attribute.

Try changing some of them and then inspect the database for what has changed.

Geert

Title: Re: What are the queries to show attribute constraints?
Post by: qwerty on February 18, 2020, 10:05:52 pm

Most of that stuff goes to t_xref. Look for client entries with the according t_attribute guid.

q.