Please check this syntaxes(NOT ONLY SYTAXES BUT A CODE TO RUN FAST)

Is this syntax correct

I want to add column to a table and set default value for that column to be 'N'

ALTER TABLE DWT00050_IMC_CCYYMM_FACT

ADD COLUMN CONTRB_DISTB_FLG char(1) {SET DEFAULT 'N'}

After altering table i have to alter view. I have to add new column to view

Please check the syntax

ALTER VIEW view_name

("column 1", "col 2", "col3", "col4")

SELECT ("col5", "col6", "col7", "col8")

FROM table_name