Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: help on modify or drop column constraint

Re: help on modify or drop column constraint

From: Hans Duijn <hans_duijn_at_inventive.nl>
Date: 23 Apr 1998 15:40:57 GMT
Message-ID: <6hnne9$4gd@news3.euro.net> 





How about...



ALTER TABLE "DEMO"."DUMMYDATE" ADD( CONSTRAINT MY_CONSTRAINT PRIMARY

KEY(NUMMER));




...for adding a primary key on column 'nummer' in schema 'demo', and...





ALTER TABLE "DEMO"."DUMMYDATE" DROP CONSTRAINT MY_CONSTRAINT CASCADE;




... for dropping the constraint.





Succes...


Received on Thu Apr 23 1998 - 10:40:57 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US