i have an existing primary key constraint, how can i add another column in this constraint(there are two existing column on this constraint)? do i need to drop this one and create another one ? how about the index referred to this contraint what will happen if i delete it ? i tried to delete it using dba studio but there's no option for it.
thanks in advance.