Subject Re: [firebird-support] Primary Key x Unique Key
Author Paul Vinkenoog
Hallo Hugo,

> When should I use a Unique Key instead of a Index?
> I know that a Unique Key does not allow duplicated values like a Primary
> Key, but what more?

That, and it creates an index automatically. Also, if you want a column to be referenced by a foreign key, it has to be either the PRIMARY KEY or UNIQUE.

Kind regards,
Paul Vinkenoog