Recreate the same table from itself with the additional column
create or replace table TABLENAME as Select col1, col2, null as newcolumn, col3, col4... from TABLENAME