# RazorSQL

## Query, Edit, Browse, and Manage Databases

- razorsql.com
- Contact

# Firebird Alter View

The Firebird Alter View Tool allows users to alter views by changing the view query using drop and create SQL statements.

Listed below is example SQL generated by the Alter View Tool.

DROP VIEW PHONE_LIST
CREATE VIEW PHONE_LIST (EMP_NO,FIRST_NAME,LAST_NAME,PHONE_EXT,LOCATION,PHONE_NO) AS SELECT
emp_no, first_name, last_name, phone_ext, location, phone_no
FROM employee, department
WHERE employee.dept_no = department.dept_no