rahulsony111 (12/8/2009)
ALTER TABLE DWT00050_IMC_CCYYMM_FACTADD COLUMN CONTRB_DISTB_FLG char(1) {SET DEFAULT 'N'}
Nope. Invalid syntax there. Check Books Online for the syntax of an ALTER TABLE ADD ... statement
ALTER VIEW view_name
("column 1", "col 2", "col3", "col4")
SELECT ("col5", "col6", "col7", "col8")
FROM table_name
Completely incorrect, that'll never run. The select statement that you've given there isn't even correct.
I suggest you look in Books online both for the basic syntax of a SELECT statement and for the syntax for CREATE/ALTER VIEW.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability