I'm actually at a loss for what a non-primary key
actually means at all (hint for creating an index, perhaps?)
This is very understandable since all databases use terminology
carelessly and without much thought put into overall conceptual integrity.
That being said I think the relational theory does not have a concept of
non-unique key.
It only talks about superkeys
http://en.wikipedia.org/wiki/Superkey
and candidate keys
http://en.wikipedia.org/wiki/Candidate_key
And of course of primary keys (that is just a candidate key picked out as the
most representative of them) and foreign keys.
So what could a key without the property of uniqueness possibly mean?
You are quite right at pointing out that it could be interpreted as an alias for
index.
- rami
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/h2-database?hl=en.
