Very frequently Jr. Developers request script for creating default constraint over table column. I have written following small script for creating default constraint. I think this will be useful to many other developers who want this script to keep handy.
ALTER TABLE Customers CONSTRAINT DF_Customers_Address2 DEFAULT 'UNKNOWN' FOR Address2
Reference : Pinal Dave (http://blog.SQLAuthority.com)