if a not null constraint is being created in addition to the primary key, then you can drop it. Yes, it will be checking not null twice.