Online Documentation for SQL Query for InterBase/FireBird

Database management tools


SQL Query 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 Query below.

 

 

Registering Databases

In order to register a single database in SQL Query for Interbase/Firebird:

  • select the Database | Register Database... main menu item or use the corresponding btnRegisterDB toolbar button;
  • check the Register a single database option and set all the necessary options using Register Database Wizard which guides you through the whole process of Database registration.

 

 

Unregistering Databases

In order to unregister a single database in SQL Query for Interbase/Firebird:

  • select the database to unregister in the DB Explorer tree;
  • select the Database | Unregister Database main menu item or use the corresponding btnUnregisterDB toolbar button;
  • confirm unregistering in the corresponding dialog window.

 

Connecting to Databases

In order to connect to a database in SQL Query for Interbase/Firebird:

  • select the database to connect to in the DB Explorer tree;
  • double-click its alias

or

  • select the Database | Connect to Database main menu item or use the corresponding btnConnectToDB toolbar button

or

  • right-click its alias and select the Connect to Database context menu item.

 

Disconnecting from Databases

In order to disconnect from a database in SQL Query for Interbase/Firebird:

  • select the alias of the database to disconnect from or any of its objects in the DB Explorer tree;
  • select the Database | Disconnect from Database main menu item or use the corresponding btnDisconnectFromDB toolbar button

or

  • right-click its alias or any of its objects and select the Disconnect from Database context menu item.