Re: how to delete a primary key constraint?

Hi Martin,

the syntax is

ALTER TABLE 'my_table' DROP CONSTRAINT 'my_primary_key'

If you like have a look at the tool Hora 3 (see http://www.keeptool.com for a 30 days free trial version of Hora 3). Its quite easy to do all administration jobs using hora.

regards Jan Dieckmann

Martin Hilpert wrote:

> Hello!
>
> Can somebody tell me the syntax of how to delete a primary key
> constraint?
>
> I tried
>
> delete from MYTABLE constraint
>
> but this raises some other constraint errors that I don't want to
> remove.
> I just want to remove the primary key constraint of ID_COLUMN of
> MYTABLE.
>
> Any ideas?
>
> Martin
Received on Wed Dec 30 1998 - 11:38:11 CST