Re: Problem with ALTER TABLE
From: J-P Korkiakoski <jaripk_at_cism.bus.utexas.edu>
Date: 1996/07/26
Message-ID: <31F8EAEC.6F61_at_cism.bus.utexas.edu>#1/1
Date: 1996/07/26
Message-ID: <31F8EAEC.6F61_at_cism.bus.utexas.edu>#1/1
Winston Douglas wrote:
> The reason you are getting that message is that you can only use that
> statement to modify a column, ie. ALTER TABLE MODIFY (COL1 VARCHAR2(9)).
> You might need to use ALTER TABLE DROP CONSTRAINT <constraint name> and
> ALTER TABLE ADD CONSTRAINT <constraint name>.
Thanks for help, everything should be working now.
Cheers,
Petteri Korkiakoski Received on Fri Jul 26 1996 - 00:00:00 CEST