RazorSQL

Query, Edit, Browse, and Manage Databases

Firebird Alter Table Add Primary Key

The RazorSQL alter table tool includes an Add Primary Key option for adding foreign keys to Firebird database
tables. The add primary key function lists all of the columns of the table and allows the user to choose
one or more columns to add to the primary key for the table. It also lists the other tables available
on the database so that the user can choose a referenced table and referenced column or columns.

Listed below is an example
of the SQL generated by the Firebird Alter Table Add Primary Key function:

ALTER TABLE EMPLOYEE ADD PRIMARY KEY (SSN)

Below is a screen shot of the add primary key function of the Firebird alter table tool.