Relationships Question....

  • Thread starter Thread starter Raj
  • Start date Start date
What is the maximum amount of 1:M relationships that you
can have in a database?
Click to expand...

Any one table is limited to 32. I'm not aware of any database-wide
limit.
[/QUOTE]

Where does that 32 come from?

I see that a table has a limit of 32 indexes. Howevew, when a table is on the
'1' side of a 1-M relationship, there isn't an index for THAT table is there...
it would be associated with the table on the 'M' side of the relationship. So
a table could be on the '1' side of 100 1-M relationships but could still only
have a single index. Or am I wrong? (I've been wrong a lot lately!)

Rick
 
What is the maximum amount of 1:M relationships that you
can have in a database?
Click to expand...

Any one table is limited to 32. I'm not aware of any database-wide
limit.
[/QUOTE]

Where does that 32 come from?

I see that a table has a limit of 32 indexes. Howevew, when a table is on
the
'1' side of a 1-M relationship, there isn't an index for THAT table is
there...
it would be associated with the table on the 'M' side of the relationship.
So
a table could be on the '1' side of 100 1-M relationships but could still
only
have a single index. Or am I wrong? (I've been wrong a lot lately!)

Rick
[/QUOTE]

Whoops... backwards (I told you I was wrong a lot lately...)

But, still the same logic applies... if you switch my '1' and 'M' around.

Rick
 
So
a table could be on the '1' side of 100 1-M relationships but could still only
have a single index. Or am I wrong? (I've been wrong a lot lately!)

Rick
Click to expand...

It may be me that's wrong: there's nothing in the Specifications help
that would indicate a limit. OTOH, that would be a very peculiar "sea
urchin" relationship diagram; but you're right, I don't see anything
that would specifically exclude it!
 
Back
Top