How we can add Default Value for a colun using Query Analyzer

Posted by Lakhangarg under Sql Server category on | Views : 1603
Suppose we have one table named Tbl_Users. and in this table we need to set 1 as default value for column RoleID.

ALTER TABLE Tbl_Users  ADD CONSTRAINT  [DF__Tbl_Users__RoleID__3B026CC2]   DEFAULT 1 FOR RoleID 

Thanks & Regards
Lakhan Pal Garg

Comments or Responses

Login to post response