22 June 2011

Firebird/Interbase SQL Add/Update/Alter Column/Field Type and Default Value

Note: Using double quotes for a string(varchar) fails! (not sure if this has anything to do with the utility I use to connect to the DB or the Firebird database itself.
ALTER TABLE my_table_name ADD my_column_name Varchar(30) default 'Not Processed' NOT NULL;


Changing the length of the email field varchar to 45 (In the users table).

ALTER TABLE users ALTER COLUMN email_address TYPE VarChar(45);