Changing a not-null column to null

"M. A. Sridhar" <[email protected]> Mon, 4 Sep 2006 14:41:27 -0700 (PDT)
Newsgroups gmane.comp.db.mckoi
Message-ID <[email protected]>
I know there is a DDL-based technique to change a not-null column to null, discussed  in the Mckoi mailling list. One problem with this approach is that an  'alter create table' drops all constraints on the table, and they will  have to be recreated. Is there a way to achieve this effect via DML? In  other words, is there some system table that we can update to make one  of the user table columns nullable? If so, please explain.
  
  Thanks in advance.
  

M. A. Sridhar 
m_a_sridhar at yahoo dot com