Ingres Alter View
The Ingres 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 administrator.full_route
create view full_route as select rt_airline, al_iatacode, rt_flight_num, rt_depart_from, rt_arrive_to, rt_depart_at, rt_arrive_at, rt_arrive_offset, rt_flight_day, al_name, al_ccode from "administrator". route rt, "administrator". airline
