Thread
:
changing the default value for a column
View Single Post
#
2
(
permalink
)
02-29-2008, 05:52 AM
David Portas
Posts: n/a
Re: changing the default value for a column
ALTER TABLE table_name
DROP CONSTRAINT name_of_default_constraint
ALTER TABLE table_name
ADD CONSTRAINT name_of_default_constraint DEFAULT 123 FOR column_name
--
David Portas
SQL Server MVP
--
David Portas
Re: changing the default value for a column