Sparx Systems Forum
Enterprise Architect => General Board => Topic started 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?
-
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)
-
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.
-
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.
-
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.
-
Thank you so much! That helped! :)