Hello,
      I've read documentation on alter table syntax and doesn't find
      anything about change column type or drop column.
      Also when i add column by command
      alter table test add column a integer not null default '10'
      It adds column but doesn't set default value.
      How can i fix it?
  
------------
With respect,
Yuri A. Kabaenkov
hellman(at)artofit(dot)com