ADD A CHECK CONSTRAINT TO CONFIRM ANY REALITY SHOW HAS AT LEAST TWO OR MORE PARTICIPANTS code example

Example: sql constraint check value in list

ALTER TABLE <table>
ADD CONSTRAINT chk_val CHECK (col in ('yes','no','maybe'))