Rename Database
Rename Database :
We can rename databases by using rename database query. For do this, we must have ALTER and DROP privileges for that database, and the CREATE privilege for the new database. This query create new database first and move tables and triggers from old database to new one.It does not change any account privileges listed in the system tables. It updates only Db column for objects such as stored routines and events.
Syntax :
RENAME DATABASE [db_name] TO [new_db_name];
Example :
RENAME DATABASE wordlisttemp TO wordlist;
