RENAME DATABASE is used to rename the existing database name to new database name.
Syntax for Rename database
RENAME DATABASE current_db_name TO new_db_name
RENAME DATABASE tih_database TO tih_db
What above query does?
Above query will rename the database tih_database to tih_db.
So this query is useful in case we find out after database creation that name is not suitable and it needs to be changed.