At 11:41 p.m. 22/04/2015, Vishal Tiwari vishuals...@yahoo.co.in
[firebird-support] wrote:
If I make all values to null of that column which is of type varchar and then
go for Alter, would you share the sql for it ?
Changing the values to null does not change the data type of the column.
On Wed, 22 Apr 2015 05:38:39 + (UTC), Vishal Tiwari
vishuals...@yahoo.co.in [firebird-support]
firebird-support@yahoogroups.com 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
On 22/04/2015 09:26, Mark Rotteveel m...@lawinegevaar.nl
[firebird-support] wrote:
Create a new column, assign/convert the values from the old column, drop
the old column, rename the new column (optional).
... and sort out, manually, however many hundreds of dependencies you
have (triggers,
On Wed, 22 Apr 2015 09:28:09 +0100, Tim Ward t...@telensa.com
[firebird-support] firebird-support@yahoogroups.com wrote:
On 22/04/2015 09:26, Mark Rotteveel m...@lawinegevaar.nl
[firebird-support] wrote:
Create a new column, assign/convert the values from the old column,
drop
the old column,
If I make all values to null of that column which is of type varchar and then
go for Alter, would you share the sql for it ?
On Wednesday, 22 April 2015 3:10 PM, Mark Rotteveel m...@lawinegevaar.nl
[firebird-support] firebird-support@yahoogroups.com wrote:
On Wed, 22 Apr 2015
Is there no Alter like SQL available ?
On Wednesday, 22 April 2015 2:01 PM, Mark Rotteveel m...@lawinegevaar.nl
[firebird-support] firebird-support@yahoogroups.com wrote:
On Wed, 22 Apr 2015 09:28:09 +0100, Tim Ward t...@telensa.com
[firebird-support]
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