Drop Default Value from Column in Sql server
Posted by Navi's on January 20, 2010
Using Alter Table script we can Drop Default value of table column in sql server using Sql Script.
ALTER TABLE [TableName] DROP CONSTRAINT [DF_CONSTRAINT_NAME]
Just pass the Your Table Name in place of [TableName] and Pass the Constraint Name in place of [DF_CONSTRAINT_NAME]