alter colum

[saritha srinivas]

print send me a script which alter a column in a table to the same name but with constraint default value as 1

[debasisdas]

as you have posted a question in the articles section it is being moved to SQL Server Forum.

MODERATOR.

[ak1dnar]

You Can try Like this.

[CODE=sql]ALTER TABLE MyTable
ADD CONSTRAINT DF_MyTable_MyCo lumn
DEFAULT ('default-Value-To-Set')
FOR MyColumn[/CODE]