Subject | Re: [firebird-support] Remove column attribute which overrides domain attribute |
---|---|
Author | Jorge Andrés Brugger |
Post date | 2007-04-10T13:01:33Z |
Martijn Tonies escribió:
Correct me if I´m wrong.
Jorge Andrés Brugger
Informática
DASU - Obra Social del Personal de la Universidad Nacional de la Patagonia
Comodoro Rivadavia, Chubut, Argentina
Teléfono (0297) 446-4444 int. 103
Correo electrónico: jbrugger@...
Website: www.dasu.com.ar
[Non-text portions of this message have been removed]
>No, it doesn't ... seems only way is touch system tables directly.
>> 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;
>
Correct me if I´m wrong.
> 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
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links
>
>
>
>
>
>
Jorge Andrés Brugger
Informática
DASU - Obra Social del Personal de la Universidad Nacional de la Patagonia
Comodoro Rivadavia, Chubut, Argentina
Teléfono (0297) 446-4444 int. 103
Correo electrónico: jbrugger@...
Website: www.dasu.com.ar
[Non-text portions of this message have been removed]