not null can be only specified as column level constraint means 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')