Online Documentation for SQL Manager for InterBase/Firebird

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;
• create a new database at the host where the selected database resides;
• register a new database using Register Database Wizard;
• unregister the selected database;
• drop the selected database;
• view/edit the selected database registration information within the Database Registration Info dialog;
• view/edit the Database properties;
• access database tools available in the Tasks submenu;
• register a new host using Register Host Wizard;
• configure representation of hosts and databases in Database Explorer;
• refresh the selected database;
• 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.

Tasks submenu allows you to:

backup database using the wizard;

restore database using the wizard;

validate database;

retrieve database statistics;

start/stop database;

recompute all indices of a database;

purge a database;

extract database objects and/or data to an Execute Script;

print metadata;

generate html report of the selected objects;

create to-do list;

manage roles and their privileges;

launch Table Altering Monitor.