Managing databases

To get started working with databases, we need a tool to manage them. Sure, you can write SQL to create tables, indices, views, and so on, but database management tools do that tedious work for us. There are many tools available that work with a variety of database products. First, we'll cover the one that comes with Delphi for managing InterBase databases.

Using the InterBase Server Manager and IBConsole

All versions of Delphi come with a tool for working with InterBase, IBConsole, and some sample databases (if you included InterBase when you installed Delphi). When working with InterBase on your Windows desktop, you must start the local InterBase server with the InterBase Server Manager (if it's not already running). This can be found in the InterBase2020\bin folder of your Delphi installation and is called IBMgr.exe; it may also be found in the Windows Start menu as "Embarcadero InterBase 2020." Its interface is very simple:

...