Adding columns to existing primary key constraint
Hi,
We wish to add some columns to the primary key of existing table.
Is this possible without dropping the constraint and recreating?
Other tables reference have fks defined against this table's pk.
Only way at moment can think of is drop constraint on other table
drop pk constraint
add pk contsraint
add dfk contrsint.
Any other ideas?
Thanks