So i have to alter table first

like ALTER TABLE table_name ADD column_name datatype

Later should i drop the view and create a new view to add that additional column?