Add a Column To An Existing Table

If you need to add a column to an existing table with a default value:

 

ALTER TABLE YourTableName

ADD YourColumnName varchar(50)

DEFAULT ‘your default value’ WITH VALUES