Andrew,
> > Can someone tell me what advantage there is to creating a table
> with a
> > primary key rather than simply adding a unique index to the table
> at a
> > later time.
If you are a serious DBA, one of the important rules to follow is "Never
create any table without a Primary Key." One can achieve the same
result by adding a UNIQUE index on a NOT NULL column later, but the
danger is that you'll forget and go into production with an un-keyed
table. Believe me, I've done it, and didn't realize what was wrong
until I got a "Could not identify unique tuple" error.
For an extensive discussion of why primary keys are important, see
"Practical Issues in Database Management" (F. Pascal).
-Josh Berkus
______AGLIO DATABASE SOLUTIONS___________________________
Josh Berkus
Complete information technology josh@agliodbs.com
and data management solutions (415) 565-7293
for law firms, small businesses fax 621-2533
and non-profit organizations. San Francisco
