[Info-Ingres] Ingres SQL question

[Martin Bowes]

Hi Simon,

 

What version of Ingres are you using?

 

>From II R3 (IIRC) there has been an alter table statement available that
will do what you want - with some caveats.

 

Martin Bowes

 

From: Simon Gilbert 
Sent: 11 September 2007 11:41
To: Michael Lay; Martin Bowes
Subject: Ingres SQL question

 

We need to change a column in one of our database tables to make it
nullable.  For the mysql databases we can use the following SQL
statement:

 

ALTER TABLE screening_part2s_audit

MODIFY consent smallint NULL

 

I have looked at the Ingres docs but there doesn't seem to be a similar
simple way of doing this for the Ingres databases. Do you have any
suggestions?

 

Simon.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.kettleriverconsulting.com/mailman/private/info-ingres/attachments/20070911/6c59082b/attachment-0001.html