DROP ALL CONSTRAINTS is only valid for ALTER DOMAIN

  Explanation:  The DROP ALL CONSTRAINTS clause only works for the
  ALTER DOMAIN statement and not the ALTER TABLE statement.

  User Action:  DROP the individual constraints by name.