Re: Primary key

From: Arlette BROSSARD <abray_at_club-internet.fr>
Date: 1999/04/08
Message-ID: <01be820d$0c26aec0$47a224c3@ntdv2113>#1/1

If the table as no primary key :

ALTER TABLE mytable
ADD CONSTRAINT pk_mytable
PRIMARY KEY (cola,colb)
USING INDEX TABLESPACE mytablespace STORAGE ( ... );

If there is a primary key and you want add a column :

ALTER TABLE mytable
DROP CONSTRAINT pk_mytable;

tyann001_at_aol.com a écrit dans l'article <370CB115.350A8F9_at_aol.com>...
> Anyone know how to add a primary key to a column on an existing table?
>
Received on Thu Apr 08 1999 - 00:00:00 CDT