To simply open and explore existing tables, use Database Explorer - this allows you to view data and create new tables.

To open the Windows version, use either of these

• Start / Programs / Interbase / Interbase Windows ISQL
• From the Database Explorer menu, select Object / ISQL... - displayed only when a SQL database is selected (hint - click on an Interbase / Firebird alias name first).

When creating a new database (*.fdb file) on a remote computer, place the remote computer's name in Server and a fully qualified path (including the drive letter) in Database. (The minimum file size is 568K.)

• Start / Programs / Interbase / Server Manager

(See Tutorial.pdf for full instructions.)

Quick Start: Firebird on Windows provides the following basic command line techniques

• Change the "sysdba" password - use GSEC
• Add a new user - use GSEC
• Explore a database - use ISQL

    "C:\Program Files\FireBird\bin\isql.exe" 
              "C:\Program Files\FireBird\examples\employee.gdb" -u sysdba -p pwd
    SQL> SHOW TABLES;
    SQL> SELECT * FROM countries;
    SQL> EXIT;
  

• Create a new database - use ISQL

   "C:\Program Files\FireBird\bin\isql.exe"
    SQL> CREATE DATABASE 'httplogs.gdb' USER 'vsbabu' PASSWORD 'vsb';
    SQL> CREATE TABLE states (state_code VARCHAR(2) NOT NULL PRIMARY KEY, 
           state_name VARCHAR(30) NOT NULL);
    SQL> INSERT INTO STATES (state_code, state_name) VALUES ('VA', 'Virginia');
    SQL> INSERT INTO STATES (state_code, state_name) VALUES ('MD', 'Maryland');
    SQL> SELECT * FROM states;
    SQL> COMMIT;
    SQL> EXIT;
  

URL: http:// cpcug.org / user / clemenzi / technical / Databases / Firebird / BasicOperations.html