changing the Default value | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

changing the Default value

I have a table MyTable, which has a Column MyColumn of bit data type with default value 1. I want to change the Default value to 0. Thanks in Advance for taking time
You need to drop the old default and add the new default constraint. —
Frank Kalis
Microsoft SQL Server MVP
http://www.insidesql.de
Heute schon gebloggt?http://www.insidesql.de/blogs
Ich unterstuetze PASS Deutschland e.V. http://www.sqlpass.de)
Look for alter table in sql server help file
Or do this in EnterPrise Manager Madhivanan Failing to plan is Planning to fail
Refer to the books online for CREATE DEFAULT, ALTER TABLE and DROP DEFAULT statements. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
]]>