alter table

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@artofit.com