Author Topic: Indexes and constraints  (Read 51 times)

erobinson

  • EA Novice
  • *
  • Posts: 10
  • Karma: +0/-0
    • View Profile
Indexes and constraints
« 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?

Richard Freggi

  • EA User
  • **
  • Posts: 354
  • Karma: +13/-7
    • View Profile
Re: Indexes and constraints
« Reply #1 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

qwerty

  • EA Guru
  • *****
  • Posts: 12336
  • Karma: +347/-287
  • I'm no guru at all
    • View Profile
Re: Indexes and constraints
« Reply #2 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.


erobinson

  • EA Novice
  • *
  • Posts: 10
  • Karma: +0/-0
    • View Profile
Re: Indexes and constraints
« Reply #3 on: Today at 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.

qwerty

  • EA Guru
  • *****
  • Posts: 12336
  • Karma: +347/-287
  • I'm no guru at all
    • View Profile
Re: Indexes and constraints
« Reply #4 on: Today at 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.