I want to change a table by adding a column. So far nothing to see here, BUT I would like to make this column part of a composite key, i.e., I now have a layout
table_name( Field_1 datatype PK, Field_2 datatype,....)
and I want the inserted column, say Field_k to be part of a PK jointly with the existing single-field PK.
I haven't found any source for how to do this or for whether it is possible or not. Any advice, please?