Thanks for responding. My main goal was to avoid any future maintenance. (My personal statement of purpose is 'It requires no effort on my part') I think I have found that the following will fulfill my needs.

SELECT * INTO #MyTable161025 FROM MyTable WHERE unqKey = 161025
ALTER TABLE #MyTable161025 DROP COLUMN UnqKey
INSERT INTO MyTable SELECT * FROM #MyTable161025
SELECT @@Identity