kaveer
5/11/2018 - 3:47 PM

Check Constraint Column Level

Create Table UserDetails(
  DetailId int,
  Username Varchar(100),
  Gender char(1) Constraint user_gender check(Gender in ('M', 'F'))
  --Will allow to enter either 'M' or 'F' in gender column
)