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

Comments (0)

Skip to main content