add constraint to quantity field such that it doesw not exceed 10 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')