- Open SQL Shell.
- Provide your username and password.
- Type the following command
CREATE DATABASE your_database_name;
- If the database is created successfully you will see the "CREATE DATABASE" message.
- Type the following command to see all the databases.
\l
- If you want to change the name of the database you can use the following command
ALTER DATABASE your_database_name RENAME TO new_database_name;
If the database name is changed successfully you will see an "ALTER DATABASE" message.
If you want to delete the database you can use the following command
DROP DATABASE your_database_name;
- If the database deletes successfully you will see a "DROP DATABASE" message.