Re: question about primary key

Floyd Wellershaus said: > It seems to me that it's better when creating a table to first add a > unique index on the column(s) you want to have a primary key on, and then > to add the primary key with the alter table add constraint statement. > It seems so, because the primary key will use the existing unique index > instead of wasting space creating another index. > > Is this thinking right ? Yes. In addition, you get to choose a sensible index name, which can make your life easier later on. -- Bye now, Obnoxio "I'm astonished anyone pays real money for this crap." -- Cosmo -- This message has been scanned for viruses and dangerous content by OpenProtect(http://www.openprotect.com), and is believed to be clean.