informix
Informix Guide to SQL: Syntax
SQL Statements

RENAME DATABASE

Use the RENAME DATABASE statement to change the name of a database.

Syntax

Element Purpose Restrictions Syntax
new_database New name for the database Name must be unique. You cannot rename the current database. The database to be renamed must not be opened by any users when the RENAME DATABASE command is issued. Database Name,
p. 4-47
old_database Current name of the database The database must exist. Database Name,
p. 4-47

Usage

You can rename a database if either of the following statements is true:

You can only rename local databases. You can rename a local database from inside an SPL routine.

Related Information

Related statement: CREATE DATABASE

Informix Guide to SQL: Syntax, Version 9.2
Copyright © 1999, Informix Software, Inc. All rights reserved