Thursday, October 2, 2014

Set table column value as mandatory


CREATE TABLE ABCD
(
MyColumn INT DEFAULT ( 1 )
NOT NULL
)
GO
ALTER TABLE [dbo].[ABCD]
WITH CHECK
ADD CONSTRAINT [CK_ABCD] CHECK (([MyColumn]=(1)))
GO





Saeid Hasani [sqldevelop]


No comments:

Post a Comment