That's correct. My lack of attention! :-)

I was also supposed to add that that would be the primary key from
the end-user standpoint. That would be the Candidate Key (or
Alternate Key, there are different names), i.e., a column (or set of
columns) that has the same characteristics as a primary key but
doesn't propagate to other tables (it doesn't become a foreign key).




--- In firebird-support@yahoogroups.com, "Martijn Tonies"
<m.tonies@u...> wrote:

>
> > Driver
> > ===============================
> > Driver_ID integer PK
> > License_Number varchar(12) Unique index - NOT NULL
>
> Unique CONSTRAINT.
>
>
> Indices are for speed, constraints for integrity.
>
> With regards,
>
> Martijn Tonies
> Database Workbench - developer tool for InterBase, Firebird, MySQL

& MS SQL

> Server.
> Upscene Productions
> http://www.upscene.com