Indexes and constraints

[erobinson]

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?

[Richard Freggi]

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

[qwerty]

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.

[erobinson]

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.

[qwerty]

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.

[erobinson]

Thank you so much! That helped!