Online Documentation for SQL Manager for InterBase/Firebird

Database Management

SQL Manager for InterBase/Firebird provides a number of tools you may need to manage your InterBase/Firebird databases.

Find the list of common database management operations for working in SQL Manager below.

 

Registering Hosts

• select the Database | Register Host... main menu item or use the corresponding Register Host toolbar button

or

• right-click any host alias and select the Register Host... context menu item in the DB Explorer tree;
• set all the necessary options using Register Host wizard which guides you through the entire process of host registration.

 

Unregistering Hosts

• select the host to unregister in the DB Explorer tree;
• select the Database | Unregister Host main menu item or use the corresponding Unregister Host toolbar button

or

• right-click the host alias and select the Unregister Host context menu item in the DB Explorer tree;
• confirm unregistering in the corresponding dialog window.

 

Creating Databases

• select the Database | Create Database main menu item or use the corresponding Create Database toolbar button;
• set all the necessary options using Create Database wizard which guides you through the entire process of creating a new database.

 

Dropping Databases

• select the database to drop in the DB Explorer tree;
• select the Database | Drop Database main menu item;
• confirm dropping in the corresponding dialog window.

 

Registering Databases

• select the Database | Register Database... main menu item or use the corresponding Register Database toolbar button

or

• right-click any database alias and select the Register Database... context menu item in the DB Explorer tree;
• set all the necessary options using Register Database wizard which guides you through the entire process of database registration.

 

Unregistering Databases

• select the database to unregister in the DB Explorer tree;
• select the Database | Unregister Database main menu item or use the corresponding Unregister Database toolbar button

or

• right-click the database alias and select the Unregister Database context menu item in the DB Explorer tree;
• confirm unregistering in the corresponding dialog window.

 

Connecting to Hosts

• select the host to connect to in the DB Explorer tree;
• select the Database | Connect to Host main menu item or use the corresponding Connect to Host toolbar button

or

• right-click the host and select the Connect to Host context menu item in the DB Explorer tree.

 

Disconnecting from Hosts

• select the host to disconnect from in the DB Explorer tree;
• select the Database | Disconnect from Host main menu item or use the corresponding Disconnect from Host toolbar button

or

• right-click the host and select the Disconnect from Host context menu item in the DB Explorer tree.

 

Connecting to Databases

• select the database to connect to in the DB Explorer tree;
• select the Database | Connect to Database main menu item or use the corresponding Connect to Database toolbar button

or

• right-click the database alias and select the Connect to Database context menu item in the DB Explorer tree.

 

Disconnecting from Databases

• select the database to disconnect from in the DB Explorer tree;
• select the Database | Disconnect from Database main menu item or use the corresponding Disconnect from Database toolbar button

or

• right-click the database alias and select the Disconnect from Database context menu item in the DB Explorer tree.

 

Viewing and Editing Database Registration Info

• select the database or any of its objects in the DB Explorer tree;
• select the Database | Database Registration Info... main menu item

or

• right-click the database alias or any of its objects and select the Database Registration Info... context menu item in the DB Explorer tree.

 

Viewing and Editing Database Properties

• select the database in the DB Explorer tree;
• right-click the database and select the Database Properties... context menu item or use the corresponding Properties toolbar button

 

Viewing and Editing Host Registration Info

• select the host in the DB Explorer tree;
• select the Database | Host Registration Info... main menu item

or

• right-click the host alias and select the Host Registration Info... context menu item in the DB Explorer tree.

 

 

---