| Subject | Re: [ib-support] Change varcahr(40) to Varchar(100) |
|---|---|
| Author | Martijn Tonies |
| Post date | 2003-02-27T10:53:44Z |
Hi Michael,
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
http://www.upscene.com
"This is an object-oriented system.
If we change anything, the users object."
> Can I change a field defined as Varchar(40) to Varchar(100) withoutYes - just fire up the Table Editor in Firebird/InterBase Workbench
> loosing data ?
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
http://www.upscene.com
"This is an object-oriented system.
If we change anything, the users object."