Create a new field in a table?

[VooDooRT]

I want to create a new field into a table that already exists. It's all part of an installation file, so I don't want to move, drop, re-create.

Thanks!

[chriskl]

RTFM dude.

ALTER TABLE blah ADD COLUMN colname type;

Chris