Re: Are primary keys always needed?

>1. Are there any cases in which a primary key is not required for a
>table? Or, Is there any good justification for having a table with NO
>primary key?

In theory, each row in a table must be identified with an unique argument. That's the theory. But even without creating a primary key, or specifying a Unique constraint, you still can use ROWID to identify specific rows (WARNING !!! use rowid only for ponctual procedures, never consider ROWID as a consistent value). But you can have specific case where a primary key isn't necessary. In general, don't use a primary key unless you are sure it is strictly necessary. Received on Fri May 21 1999 - 09:34:28 CEST