The check constraint should only be applied when the column is updated so depends on your usage.