Firebird SQL

• Open the Firebird SQL Website.
• Download the desired Firebird according to your system requirement.

• Run the setup as administrator.

• Accept the license agreement.

• Check all components in the list.

• Set the installation path, to install the file.

• Setup a password to connect the ISQL.

• Click Install to start installing the Firebird SQL files.

• Installs the SQL with all specifications.

• Click finish to complete the installation.

Fire Bird Getting Started and SQL Syntax:

Connecting and Creating Database:

• Fire Bird creates the extra file for every database.
• We need to specify the folder path of the database where it should be saved.
• Below is syntax to store the database file while creating.
• After creating database, you need to enter credentials to connect.
• Enter the user and password details.

• File created saved in the folder.

Write:

• We need to create the table to store the database.
• Below is syntax to create the table.

Insert:

• insert into gives the values to each column in the row.

Read:

• Select, collects all the values in the table.

Filter:

• Select Where retrieves the specific column values with desired conditions.

Update:

• Alter Alter Column changes the data type of the column.

• Alter Add creates the new column.

• Update add the values to newly created column.
• changes the old value to new value.

• Alter Drop deletes the specific column in the table.