You can modify or drop a check constraint in SQL using the ALTER TABLE statement. To modify a check constraint, you need to drop the existing one and create a new one with the updated condition.