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

"M. A. Sridhar" <[email protected]>
Newsgroups gmane.comp.db.mckoi
Message-ID <[email protected]>
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


		
__________________________________ 
Do you Yahoo!? 
Meet the all-new My Yahoo! - Try it today! 
http://my.yahoo.com 
 



---------------------------------------------------------------
Mckoi SQL Database mailing list  http://www.mckoi.com/database/
To unsubscribe, send a message to [email protected]
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.