Subject | RE: [firebird-support] Remove column attribute which overrides domain attribute |
---|---|
Author | Alan McDonald |
Post date | 2007-04-10T13:27:07Z |
> Martijn Tonies escribió:have you tried just setting the collation to the same as the domain?
> >
> >> 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;
> >
> No, it doesn't ... seems only way is touch system tables directly.
> Correct me if I´m wrong.
>
Alan