Re: Changing a not-null column to null

Hi,

Unfortunately the Mckoi system tables can not be altered to achieve 
this.  The meta data system tables in Mckoi are read-only views of the 
table definitions.  It would be a nice trick to be able to update these 
constraint attributes by modifying the system tables, and this is an 
interesting idea that Mckoi might be able to support.

Toby.

M. A. Sridhar wrote:

> I know there is a DDL-based technique to change a not-null column to 
> null, discussed <http://mckoi.com/database/mail/subject.jsp?id=7300> 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|



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