Subject Re: [firebird-support] Remove column attribute which overrides domain attribute
Author Helen Borrie
At 10:33 PM 10/04/2007, you wrote:


> > 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