When I created the table, I defined default for
certain columns (e.g., current_timestamp).

Now, I need to remove such defaults. The alter
table ... alter column ... does not have the syntax
to remove the default.

Other than dropping and recreating the columns,
is there an easy way?

Thanks,

Binh
http://vmdd.tech.mylinuxisp.com/catalog/