News:

To still receiving newsletters from us please subscribe to our Newsletters:
http://tech.groups.yahoo.com/group/developers-Heaven/

Main Menu

How to Alter column with a Default constraint

Started by admin, March 08, 2011, 03:24:41 AM

Previous topic - Next topic
Print
Go Down Pages1
User actions

admin

March 08, 2011, 03:24:41 AM
1- Drop the constraint first.
2- Alter the column.
3- recreate the constraint again.
Code Select

ALTER TABLE dbo.TPURENTRY
DROP CONSTRAINT TPURENTRY_ADDITIONNALINFO_DF
GO

ALTER TABLE dbo.TPURENTRY
ALTER COLUMN ADDITIONNALINFO VARCHAR(MAX) NULL
GO

ALTER TABLE dbo.TPURENTRY 
ADD CONSTRAINT TPURENTRY_ADDITIONNALINFO_DF DEFAULT '' FOR ADDITIONNALINFO
GO
Print
Go Up Pages1
User actions