> How can I change size of varchar field in the table? With oracle I can do
> alter table TABLE_NAME modify FIELD_NAME VARCHAR(new_size)
> but it doesn't work with firebird...

Sure it does, but you need to use the right syntax:

ALTER TABLE table_name
ALTER column_name TYPE new_datatype

eg:

ALTER TABLE CONF
ALTER CONF_VALUE TYPE VarChar(20)

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com