Is there a way to change which column in a table is the primary key without destroying and recreating the table? I just ran into this issue today and after much searching I resorted to that method (of course I also stored the data in a temp table), but naturally I'm wary of doing that with live data involved. If you know of a safer method I can use for future reference, it'd be much appreciated.
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.