Create a database
To create a new database, control-click the server where the
database should be created in the Server Navigator, click
New Database in the Connection Menu.
After you create a new database, you must perform additional
steps to define the tables, queries and reports that will
make up your database.
Open a database
After connecting to the server, Double click on the preferred
database
to show all the tables, queries and backups associated with
the database.
Rename a database
To rename a database, control-click on the database in the Server
Navigator and select and select Database Properties. Use Database
Name edit box to rename it.
Delete a database
To delete a database, select the database in the Server Navigator
and click Drop Database in the connection menu. A confirmation
dialog will prompt you before deleting the database.
NOTE: Be very careful
when deleting a database, the operation is irreversible.
Copy a database
You can copy a database from one server to another or to the
same server under a different database name by using Navicat's
Data Transfer function.
Move a database
You can move a database from one server to another by copying
the database to where you want it and then delete the original
one.
Maintain a database
Please visit Maintaining
your Database/Tables for details
|