On Wed, 22 Apr 2015 05:38:39 +0000 (UTC), "Vishal Tiwari [email protected] [firebird-support]" <[email protected]> wrote: > Hi All, > I have a Table called Table1, in that I have a column called Status which > is of type Varchar and contains values link '1', '2', '3' etc, i.e. all > integer values only but in Varchar type. > I need to change this column's datatype to Integer for some reason, any > idea how do we do it ? > I am trying like: > ALTER TABLE Table1 ALTER STATUS TYPE Integer; > But I am getting an error like, "Cannot change datatype......."
Create a new column, assign/convert the values from the old column, drop the old column, rename the new column (optional). Mark
