SQL Rename Database Tutorial for Beginners
SQL - RENAME DATABASE
Definition
RENAME DATABASE is used to change the name of an existing database. However, in modern versions of MySQL, the RENAME DATABASE command has been removed and is no longer supported. To rename a database, you typically create a new database and move all tables from the old database to the new one.
Syntax (Older MySQL Versions)
RENAME DATABASE old_database_name
TO new_database_name;
example:
RENAME DATABASE college_db
TO student_db;