On Fri, 28 Sep 2001, Ryan Ho wrote:
> I've dropped an primary key index in order to re-create it. but i realized
> that i can't recreate a primary key index. Will a unique index be an adequate
> replacement? will the database integrity be at risk as a result?
I think that 'PRIMARY KEY' in a table definition is just shorthand for
'UNIQUE NOT NULL', in addition to whatever magic is required to mark the
column as primary so that 'REFERENCES' constraints in other tables know
which column to default to.
If all you did was delete the index and recreate it, you should be fine --
as far as I know there is nothing in the index itself marking it as
"primary".
--
Tod McQuillin
P.S. If I am wrong or incomplete in my speculations above, I am sure
someone will jump in and correct me, which is exactly what I'm hoping for.
The best way to get correct answers on a mailing list is to post wrong
answers :-)