alter table Customers
alter column CustomerID int not null

alter table Customers
add primary key (CustomerID)