> but I get a syntax error after I do this
>
> alter table vaccine drop constraint 'INTEG_400'

Try:

alter table vaccine drop constraint INTEG_400;

The single-quotes imply a value, not an object name, and constraints are named
objects.