Code has been added to clipboard!

Altering a Column with SQL Default Value

Example 
ALTER TABLE Person
ALTER COLUMN CityID SET DEFAULT 'Ben';
Related article