Hi all, sorry if this is such a newbie question but I have read
through the documentation and I just dont get it. I am in the
process of learning Firebird, and I want to move away from MSSQL. :)

I need to alter a column with a new default. Here is what I am
doing right now:

alter table CUSTOMERROOT
alter DATECREATED TYPE TIMESTAMP DEFAULT CURRENT_TIMESTAMP;

I get an error about invalid token: DEFAULT.

So what is the correct synatax to alter a columns default?

Thanks in advance!

Greg

PS. Is there a good newbie site out there?