| Subject | RE: [firebird-support] Change domain name |
|---|---|
| Author | Johan Visage |
| Post date | 2003-10-07T08:21:35Z |
Hi Luiz,
I have not tried this myself, but I have an idea:
First add a domain called DD_NOTE, then use ALTER TABLE to add the new
domain and drop the old one in all the tables that used NOTE, then DROP
DOMAIN NOTE. This could work. Altering the domain name in the way that you
are trying will certainly not work, because, like the message says, there
are dependancies on that domain.
Johan
If you are not the intended recipient, employee or agent responsible for delivering the message to the intended recipient, you are hereby notified that any dissemination or copying of this communication and its attachments is strictly prohibited.
If you have received this communication and its attachments in error, please return the original message and attachments to the sender using the reply facility on e-mail.
Internet communications are not secure and therefore the UCLES Group does not accept legal responsibility for the contents of this message. Any views or opinions presented are solely those of the author and do not necessarily represent those of the UCLES Group unless otherwise specifically stated.
This footnote also confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses although this does not guarantee that this email is virus free.
**********************************************************=
I have not tried this myself, but I have an idea:
First add a domain called DD_NOTE, then use ALTER TABLE to add the new
domain and drop the old one in all the tables that used NOTE, then DROP
DOMAIN NOTE. This could work. Altering the domain name in the way that you
are trying will certainly not work, because, like the message says, there
are dependancies on that domain.
Johan
> -----Original Message-----=**********************************************************
> From: Luiz [SMTP:cprmlao@...]
> Sent: Monday, October 06, 2003 10:57 PM
> To: fb-support
> Subject: [firebird-support] Change domain name
>
> Hi,
>
> I have a domain called 'NOTE' and I'd like to change your name to
> 'DD_NOTE'.
>
> I have tried the next:
> ALTER DOMAIN NOTE TO DD_NOTE
> But, this give me an error saying that dependencies exist.
>
> I have many columns in several tables of the type NOTE.
>
> I didn't like to create a new DB and pump the data.
>
> Is there a easy way to do it?
>
> Thanks in advance,
>
> Luiz.
>
>
>
> To unsubscribe from this group, send an email to:
> firebird-support-unsubscribe@yahoogroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
If you are not the intended recipient, employee or agent responsible for delivering the message to the intended recipient, you are hereby notified that any dissemination or copying of this communication and its attachments is strictly prohibited.
If you have received this communication and its attachments in error, please return the original message and attachments to the sender using the reply facility on e-mail.
Internet communications are not secure and therefore the UCLES Group does not accept legal responsibility for the contents of this message. Any views or opinions presented are solely those of the author and do not necessarily represent those of the UCLES Group unless otherwise specifically stated.
This footnote also confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses although this does not guarantee that this email is virus free.
**********************************************************=