Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Jiri Lisicky — — source: Informix-list mailing list archive (1991-1998)
On 08 Feb 1999 12:48:57 +0000, Mark Oberfield
<oberfiel@haze.nws.noaa.gov> wrote:
>Hi,
>
>I am reasonably confident of the answer but I want to confirm it with
>the sages in this newsgroup.
>
>Is there a way to change the name of a database without having to
>export it, twiddle the schema file, and then re-create it with the new
>name?
>
>My pointy-haired boss has suggested that I change the name in the
>sysdatabases table. I don't think that is a good idea but I don't
>have the luxury of having an "offline" IDS 7.30 server to corrupt or
>experiment with.
>
>Mark
It is simple !
RENAME DATABASE old_dbs TO new_dbs
--
Jiří Lisický ČD DATIS Olomouc
e-mail: lisicky@datis.cdrail.cz Nerudova 1
phone: +420-068-472-5496 Olomouc, Czech Republic
>>> čeština ISO-8859-2 Compatible <<<
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.