Subject | Re: [firebird-support] Remove column attribute which overrides domain attribute |
---|---|
Author | Helen Borrie |
Post date | 2007-04-10T13:44:08Z |
At 10:33 PM 10/04/2007, you wrote:
alter table mytable
ALTER mycolumn TYPE yourdomain
./heLen
> > I can define a domain to be, for example, varchar(10) collate es_es.Maybe in MySQL it would. :-)
> > 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;
alter table mytable
ALTER mycolumn TYPE yourdomain
./heLen