On Tue, May 03, 2005 at 11:57:31 +0200,
tövis <tovises@freemail.hu> wrote:
> Hi All
> Seem to be that I can not create KEY exclude PRIMARY and FOREIGN.
> This means for one table I can create only one key.
> All other, frequently used operations (browse, search) should use INDEX-es (may be unique).
> Is these statemens are correct?
The FOREIGN KEY clause doesn't create keys.
You can use UNIQUE and NOT NULL clauses to create candidate keys.