How to change the default value for SQL server2000 database column properties is 0

--If the field does not have a default value, execute the following statement directly, adding the default value:
ALTER TABLE name add default (1) for field name

-If you have a default value, now you want to change the default value, you need to drop the original default value before adding a new default value
ALTER TABLE table name DROP constraint default value constraint name

--If you do not know the name of the default constraint, query with the following statement:
SELECT [Name]
From sysobjects T
WHERE id = (select Cdefault from syscolumns where id = object_id (N ' table name ')
and name= ' field name ')

How to change the default value for SQL server2000 database column properties is 0