Subject Re: [firebird-support] Remove column attribute which overrides domain attribute
Author Martijn Tonies
> > > 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
> > > "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
My thoughts:
Database development questions? Check the forum!