> > > I can define a domain to be, for example, varchar(10) collate es_es.
> > > Then I can use that domain in a table column, and I can override the
> > > collate attribute (for example, I can define that column as collate
> > > pt_br, even when the domain is collate es_es).
> > >
> > > How do I remove from table column that overriding attribute? (or, how

to

> > > "inherit" domains props again).
> >
> >I haven't tried it, but would this work?
> >
> >alter table mytable modify mycolumn yourdomain;
>
> Maybe in MySQL it would. :-)
>
> alter table mytable
> ALTER mycolumn TYPE yourdomain
>
> ./heLen

Left as an exercise for the reader ;)





So much for the reply from the original poster though, he said:
"doesn't work", so I figured the collation modification didn't work.
Apparently, the whole statement didn't work? :-)


Martijn Tonies
Database Workbench - development tool for Firebird and more!
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com