> >> 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.
