Home
Browse Code Add-Ins Blog Language Feeds Service Stats FAQs Feedback About
Manage Your Code
Snippet: Add default value to existing column (SQL)
Title: Add default value to existing column Language: SQL
Description: Add default value to an existing column in database table http://dev-for-fun.blogspot.com/2007/08/add-default-value-to-existing-column.html Views: 1326
Author: Filip K Date Added: 10/19/2008
Copy Code   
ALTER TABLE TableName WITH NOCHECK
ADD CONSTRAINT DF_DefaultName DEFAULT 'Default Value' FOR ColumnName