On 27 Aug 2003 at 16:21, Ed0302 wrote:

>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.

Primary key usually used for exact row addressing. If you don't
need it nobody forces you to use it. Except software described below.

>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?

Paradox (BDE) for example is unable to make secondary indices
maintained without primary key.
May be the presenter ment well-know holywar "natural keys vs
surrogates"?

SY, Dimitry Sibiryakov.