If we need to ensure that my table column should get assigned to specific value which constraints should be used code example
Example: how to permit only a few values in dbms
ALTER TABLE [TableName] ADD CONSTRAINT
my_constraint CHECK (PatientType = 'Admitted' OR PatientType = 'OPD')