Alter Default on a Column

Gert · November 26th, 2003, 04:20 AM

Does anyone know if it is possible, via the ordinary ALTER TABLE, to change an existing DEFAULT on a varchar column? I know that it is possible through EM, but I need to do it in a script. I've tried the syntax from BOL, but keeps getting SYNTAX ERROR.

Could someone please help me with an example?

Thank you in advance.

Gert

jemacc · November 26th, 2003, 09:40 AM

Can you post your syntax ?

Gert · November 26th, 2003, 10:39 AM

Thanks for your reply, but I found it out my self.

Code:

ALTER TABLE Anlegg DROP CONSTRAINT DF_Anlegg_Landkode 

ALTER TABLE Anlegg ADD CONSTRAINT DF_Anlegg_Landkode DEFAULT 'FR' FOR landkode

alyeng2000 · November 28th, 2003, 03:56 AM

your sentax is right and i executed it..
Try this code as another way to do default

CREATE DEFAULT DF_Anlegg_Landkode AS 'FR'

sp_bindefault DF_Anlegg_Landkode , 'tablename.landkode'

plz inform me with the result

Ahmed Ali
Software Developer

Gert · November 28th, 2003, 08:58 AM

I know the syntax is right. It works fine now with me (I wrote that I found it out my selv.. :-)

Thanks anyway for answering.

Gert