Subject | Re: [firebird-support] Remove column attribute which overrides domain attribute |
---|---|
Author | Martijn Tonies |
Post date | 2007-04-10T12:33:55Z |
> I can define a domain to be, for example, varchar(10) collate es_es.I haven't tried it, but would this work?
> 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).
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