This, too, is new to me. The first table column is a contrived key that is
no longer needed as a unique row identifier. The second column should
replace the first as the primary key. The ALTER TABLE command can add a
primary key to a column, but I don't see how to remove that constraint from
column1, add it to column2, so I can drop column1.
Pointers, please.
Rich
--
Richard B. Shepard, Ph.D. | The Plain English Science Consultant
Applied Ecosystem Services, Inc. | Helping Ensure Our Clients' Futures
<http://www.appl-ecosys.com> Voice: 503-667-4517 Fax: 503-667-8863