Hi Ed,

> I have a number of tables that don't need a primary key--just a
> foreign key, i.e. there is no reason in the foreseeable future I
> would access the data by the primary key. But recently at a user
> group meeting, the presenter stated that he adds a PK to all tables.
> Is there an advantage to adding a PK to the tables that don't need
> them?

Advantage - I don't know.

Fact is, without a primary key - or at least a couple of columns
being a candidate PK - you don't have ANY means of addressing
a single record after you've a couple of records into a table.


With regards,

Martijn Tonies
Database Workbench - the developer tool for InterBase & Firebird
Upscene Productions
http://www.upscene.com