Sparx Systems Forum

Enterprise Architect => General Board => Topic started by: erobinson on October 27, 2021, 07:27:45 pm

Title: Indexes and constraints
Post by: erobinson on October 27, 2021, 07:27:45 pm
If I create indexes and constraints on certain columns, in which EA table will I find this? I can see the basic information in t_attribute, and I notice there is a t_attributeconstraints table, but not finding any helpful information there. Any ideas?
Title: Re: Indexes and constraints
Post by: Richard Freggi on October 27, 2021, 10:21:55 pm
QWERTY's book has the answers to questions you don't even know you need to know.  A must if you are querying the repository.  I cannot recommend it enough!  (Saved my bacon a few times)

https://leanpub.com/InsideEA (https://leanpub.com/InsideEA)
Title: Re: Indexes and constraints
Post by: qwerty on October 27, 2021, 11:02:29 pm
Since you're talking about Indexes you likely deal with EA's database MDG? I'm not using that, but attributes of tables are in t_attributes. For the constraints I would need to know how to create them. After that I could have a look.

@Richard Thanks for the flowers :-)

q.

Title: Re: Indexes and constraints
Post by: erobinson on October 28, 2021, 01:44:16 am
Thanks for the quick replies! Really useful book, I'm certainly getting one!

I found the basic information in the t_attribute table, but not the additional information regarding the constraints / indexes. I create the index by following the steps below:
1.) Right-click on the Table element I created --> Features --> Constraints/Indexes
2.) Provide a name for the index, choose the Type of constraint (in my case 'index'), choose the column on which the index applies from the Available Columns list.
Title: Re: Indexes and constraints
Post by: qwerty on October 28, 2021, 02:59:56 am
The index ended up in t_operation. It's not my area and it was not obvious how to create a table, let alone an index. Hope that gets you going.

q.
Title: Re: Indexes and constraints
Post by: erobinson on October 28, 2021, 07:36:19 pm
Thank you so much! That helped!  :)