Subject Re: [firebird-support] How To Change Column DataType From Varchar To Integer ?
Author Mark Rotteveel
On Wed, 22 Apr 2015 09:00:18 +0000 (UTC), "Vishal Tiwari
vishualsoft@... [firebird-support]"
<> wrote:
> Is there no Alter like SQL available ?

There is, but it doesn't support conversion from (VAR)CHAR to INTEGER. The
conversion isn't done at ALTER time, but when the field is queried or
updated. This means that Firebird cannot ensure that current values are
convertible to INTEGER, and therefor the conversion is not allowed.