Code has been added to clipboard!

Altering a Column with SQL Default Value

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