Online Documentation for SQL Manager for MySQL

Database context menu

The context menu of a registered database in the DB Explorer tree allows you to:

• connect to the selected database (if connection to the database is not active yet);
• disconnect from the selected database (if connection to the database has been already activated);
• add the DDL of the database or of the objects it contains to the AI Assistant context;
• view/edit the selected database registration information within the Database Registration Info dialog;
• view/edit the Database properties;
• register a new database using Register Database Wizard;
• unregister the selected database;
• unregister the host where the selected database resides;
• configure server properties;
• configure representation of hosts and databases in Database Explorer;
• refresh the selected database or server objects;
• create a new tab for the selected database to access it through this tab quickly and/or manage the existing tab;
• search for an object within the tree.

AI Assistant submenu allows you to:

• add the DDL of the database itself to the context with Add object DDL to chat;
• add the DDL of all the objects the database contains with Add subtree DDL to chat; what goes into the metadata snapshot is set on the Context tab.

Using the Database tools submenu you can do the following:

Open SQL Script Editor;

Open Visual Query Builder;

Use Print Metadata tool;

Extract Database;

Create HTML Report;

Browse Dependency Tree;

Open Visual Database Designer;

Copy Database;

View information concerning database - Show submenu.