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 to
> "inherit" domains props again).

I haven't tried it, but would this work?

alter table mytable modify mycolumn yourdomain;

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com