|Subject||Re: [firebird-support] Remove column attribute which overrides domain attribute|
> > > I can define a domain to be, for example, varchar(10) collate es_es.to
> > > 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).Left as an exercise for the reader ;)
> >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
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? :-)
Database Workbench - development tool for Firebird and more!
Database development questions? Check the forum!