Can you drop a primary key constraint?

A developer just approached me with the need to drop the primary key constraint from a table. Is this possible with 8i? I told him to create a tmp table as a select * from the table, drop the table with the pkey, then recreate the table by doing a select * from the temp table, this time specifying no pkey.

Is this the best way?

Thanks,
CC Received on Thu Apr 12 2001 - 17:02:34 CDT