DataBase > SQL Server
How to Alter column with a Default constraint
(1/1)
admin:
1- Drop the constraint first.
2- Alter the column.
3- recreate the constraint again.
--- Code: ---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
--- End code ---
Navigation
[0] Message Index
Go to full version