Re: How can I change a 'not null' column to null?

You will need to use the Mckoi SQL specific extension 'ALTER CREATE 
TABLE' to alter the column.  For example, if your table contains three 
columns 'a', 'b', 'c' and was created with the following command;

CREATE TABLE ATable (
   a INTEGER,
   b INTEGER NOT NULL,
   c INTEGER
)

Now you wish to remove the NOT NULL constraint from 'b' you may use the 
following command;

ALTER CREATE TABLE ATable (
   a INTEGER,
   b INTEGER,
   c INTEGER
)

With global table altering commands like this, it is a good idea to make 
a backup before you perform the operation because a typo in the command 
could destroy data.  For example, if the altered table definition 
doesn't contain a column in the original table it will be deleted.

Toby.


M. A. Sridhar wrote:

> Hi,
> 
> I have a table with lots of rows in it, and the requirement now is to change
> one of the non-null columns (which happens to be a foreign key, if that's
> relevant) from 'not null' to 'null'. Can someone please tell me the magic SQL
> incantation to achieve this? 
> 
> I'm using Mckoi 1.0.2.
> 
> Thanks in advance.
> 
> =====
> M. A. Sridhar



---------------------------------------------------------------
Mckoi SQL Database mailing list  http://www.mckoi.com/database/
To unsubscribe, send a message to [email protected]