<<< 11. 4. 2003 16:10 - Riho-Rene Ellermaa "r.ellermaa@..." >>>
RRE> What is the syntax for setting not nullable column to nullable?
-------------------------------------------
My answer:
----------
If I need do this:

1. ALTER TABLE MYTABLE ADD NEWCOL INTEGER;
2. UPDATE MYTABLE SET NEWCOL=OLDCOL;
3. ALTER TABLE MYTABLE DROP OLDCOL;
4. ALTER TABLE MYTABLE ALTER NEWCOL TO OLDCOL;

--
Best regards, TRoland
http://www.rotursoft.sk