[firebird-support] Primary Key x Unique Key

2013-07-25 Thread Hugo Eyng
Hello. 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? Is there some advantage using a Unique Key? A Unique Key is the same that Alternate Key? -- Atenciosamente, Hugo Eyng

Re: [firebird-support] Primary Key x Unique Key

2013-07-25 Thread 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

Re: [firebird-support] Primary Key x Unique Key

2013-07-25 Thread 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