Subject Re: [firebird-support] FB3 alter domain colltion
Author Carlos H. Cantu
Re: [firebird-support] FB3 alter domain colltion

The question is why i can not do this?
I need to change collation to perform order and UPPER without need to include COLLATE in it

I guess the reason is that user may have existing indexes on fields using the domain. Changing the collate would need to have the indexes rebuilt, otherwise they would be "corrupted". So, to avoid that, FB doesn't allow such changes.

Carlos -