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
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
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