Creating and Dropping Databases
Last modified: October 18, 2023
Database is MySQL schema object that represents a folder containing tables. Tables can not exist outside a database. In MySQL 3.23 database has only one property - Name. In the later versions of MySQL, Charset and Collation are added.
Creating a Database
-
In Database Explorer, right-click a connection node and select New Database.
- or -
Select New Database on the Database menu.
- Input name of the database.
- Select Character set and Collation.
- Click Apply Changes, and, if specified name is unique, the database will appear in Database Explorer.
Editing a Database
- In Database Explorer, right-click a database node and select Edit Database on the shortcut menu.
- Select Character set and Collation.
- Click Update Database.
Note
Database can be renamed only on MySQL 5.1.7 - 5.1.23 and 6.0.0. You can not rename database in other MySQL versions.
Dropping a Database
Drop a database by selecting Delete on the node shortcut menu.
Note
When you drop database all tables and data containing within it are lost.
Want to find out more?
Overview
Take a quick tour to learn all about the key benefits delivered by dbForge Studio for MySQL.
All features
Get acquainted with the rich features and capabilities of the tool in less than 5 minutes.
Request a demo
If you consider employing this tool for your business, request a demo to see it in action.