Icon RENAME DATABASE

Renames an existing database.

Syntax
RENAME DATABASE <Name> TO <Name>

Usage
Use this statement to rename a database.

Examples
-- The following statement renames the Support
-- database to MainSupport

RENAME DATABASE "Support" TO "MainSupport"

Required Privileges
The current user must be granted the system-defined Administrators role in order to execute this statement. Please see the User Security topic for more information.

SQL 2003 Standard Deviations
This statement deviates from the SQL 2003 standard in the following ways:

DeviationDetails
ExtensionThis SQL statement is an ElevateDB extension.
Image