dropping defaults

[ZIGGY]

I have run the following script to create a default on a table:

alter table TableXYY
add default 0 for ColumnX

Now, how do I delete this default (without re-creating the table)??

Thanks

[Jim]

If you did not name the contraint then SQL created a name for it. Just look up the name and run something like the following.

alter table TableXYY
drop constraint DF__TableXXYY__ColumnX__16EE5E27


------------
ZIGGY at 7/6/01 3:34:08 PM

I have run the following script to create a default on a table:

alter table TableXYY
add default 0 for ColumnX

Now, how do I delete this default (without re-creating the table)??

Thanks