« previous next »
Pages: [1]

Author Topic: What are the queries to show attribute constraints?  (Read 2575 times)

Richard Freggi

  • EA User
  • **
  • Posts: 493
  • Karma: +18/-7
    • View Profile
What are the queries to show attribute constraints?
« 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!
Logged

Geert Bellekens

  • EA Guru
  • *****
  • Posts: 13404
  • Karma: +567/-33
  • Make EA work for YOU!
    • View Profile
    • Enterprise Architect Consultant and Value Added Reseller
Re: What are the queries to show attribute constraints?
« Reply #1 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
Logged

qwerty

  • EA Guru
  • *****
  • Posts: 13584
  • Karma: +396/-301
  • I'm no guru at all
    • View Profile
Re: What are the queries to show attribute constraints?
« Reply #2 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.
Logged
Pages: [1]
« previous next »