Dropping Default Constraints
To drop a default constraint:
1.In the Online Browser, right-click the column on which the default constraint is and select Drop Default Constraint from the context menu.
2.Click the Execute Change Script 
button in the Database Structure Change Script window.