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 btnRegisterHost 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 btnUnregisterHost 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 btnCreateDB 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 btnRegisterDB 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 btnUnregisterDB 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 btnConnectToDB Connect to Host toolbar button

or

 

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 btnDisconnectFromDB Disconnect from Host toolbar button

or

 

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 btnConnectToDB Connect to Database toolbar button

or

 

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 btnDisconnectFromDB 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 btnDBProperties 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

 

Availability:

Full version (for Windows)

Yes

Lite version (for Windows)

Yes

Note: To compare all features of the Full and the Lite versions of SQL Manager, refer to the Feature Matrix page.