> >> I doesn't appear that ALTER TABLE can change constraint
> >> characteristics. You'd have to drop/recreate, no?
> >
> > Now that you mention it, I've never tried it or seen it done.
> > Here I what I came up with:
> >
> [snip]
> >
> >
> > It is nice to see things work so well. :-)
>
> It would be interesting to see how well it works on a 50M row table.
Good point, but hopefully only small fraction of the 50 M rows would be affected and hopefully
updating primary keys isn't a common occurrence.
Regards,
Richard Broersma Jr.