At 06:03 PM 4/20/2005, Steve Fogelsen wrote:
Razzak,
Thanks for the response.
I have a number of databases I need to perform this to, so I would like to automate it.
Steve,
In that case, simply use the ALTER TABLE tablename ALTER COLUMN colname datatype
Example:
CONNECT ConComp
ALTER TABLE Customer ALTER COLUMN CustID INTEGER
That will take off the "Not Null" constraint from CustID in Customer table.
That's all there is to it!
Very Best R:egards,
Razzak.
