> I tweaked things so that the clustered flag is preserved for indexes
> that aren't directly affected by the ALTER TYPE. It would take more
> work to preserve the setting for an index that is rebuilt by ALTER TYPE,
> and I'm not even sure that it's sensible --- the new index could have
> a significantly different ordering from the old. What do you think?
Out of interest what happens to other column features such as the
existing statistics level and the existing storage spec? I guess these
might have to change when type changes??
Chris