Re: how to modify a CHECK column-constrait ?

Connor McDonald wrote in message <37982D0C.4955_at_yahoo.com>...
>Ruud Schmeitz wrote:
>>
>> Hi readers,
>>
>> After working for more than 10 year with DEC's (now Oracle's) Rdb, we're
>> now converting our databases to Oracle.
>>
>> I've found 2 annoying problems. According to the SQL Reference Manual
>> (Oracle 7.3 and 8.0) it is not possible to:
>> 1. modify an existing CHECK column-constraint;
>> 2. drop a column from a table;
>>
>> Is this really true (I just hope it ain't) ?
>> Are there any work-arounds ?
>>
>> Kind regards and TIA,
>>
>> ============================================================
>
>Drop column appears in 8i.

Don't know about 8i, but it's not in the CD-ROM Reference Manual, Release 8.0, December 1997 .

>alter table modify ... has been around since Noah was a lad...

Sure, but without the option to modify a CHECK column-constraint, only the NOT NULL constraint.
Perhaps we'll have to wait till this Noah guy is a grown man. :-)

>Cheers
>--
>===========================================
>Connor McDonald
>"These views mine, no-one elses etc etc"
>connor_mcdonald_at_yahoo.com
>
>"Some days you're the pigeon, and some days you're the statue."

"Live Long and Prosper" - Spock
"And let Wisdom be your Guide" - Spock's brother

Ruud Schmeitz
Universiteit Maastricht Received on Fri Jul 23 1999 - 13:29:21 CDT