Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Renaming a database...

0 views
Skip to first unread message

Doom Dog

unread,
Jul 18, 2001, 7:37:48 PM7/18/01
to

Is there a simple way to rename an informix database?
Ref v7.31.uc5, AIX 4.3.3.

Thank you...
Marty

__________________________________________________
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail
http://personal.mail.yahoo.com/

Bernstein, Rick

unread,
Jul 18, 2001, 7:52:02 PM7/18/01
to

See page 2-427 of Informix Guide to SQL Syntax manual.

RENAME DATABASE <old-name> TO <new-name>;

You need to be current on another database, such as
sysmaster before you issue this command.

Татьяна Ильиных

unread,
Jul 18, 2001, 10:53:17 PM7/18/01
to
RENAME old database name TO new database name


Doom Dog <doom...@yahoo.com> пишет в
сообщении:9j58b1$6hj$1...@news.xmission.com...

Paul Watson

unread,
Jul 19, 2001, 5:07:42 PM7/19/01
to
Over to Obnoxio - he's the expert :-))

--
Paul Watson #
Oninit Ltd # You are only young once
Tel: +44 1436 672201 # but you can be immature
Fax: +44 1436 678693 # for ever
www.oninit.com #

Obnoxio The Clown

unread,
Jul 20, 2001, 1:11:00 AM7/20/01
to
On Thu, 19 Jul 2001, Paul Watson wrote:
>Over to Obnoxio - he's the expert :-))

Oh sure. You f*** one little goat...

>Doom Dog wrote:
>>
>> Is there a simple way to rename an informix database?
>> Ref v7.31.uc5, AIX 4.3.3.

RENAME DATABASE x TO y;

?

0 new messages