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]