Subject Re: [ib-support] Change varcahr(40) to Varchar(100)
Author Martijn Tonies
Hi Michael,

> Can I change a field defined as Varchar(40) to Varchar(100) without
> loosing data ?

Yes - just fire up the Table Editor in Firebird/InterBase Workbench
and change it :)

Or issue an:

ALTER TABLE... statement:

ALTER TABLE tablename
ALTER columnname TYPE VarChar(100)

With regards,

Martijn Tonies
InterBase Workbench - the developer tool for InterBase & Firebird
Firebird Workbench - the developer tool for Firebird
Upscene Productions

"This is an object-oriented system.
If we change anything, the users object."