ALTER TABLE distributors
  ADD  CONSTRAINT zipchk CHECK (length(zipcode) = 6);