Alter View Tool

The 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 public.employee_view

CREATE VIEW public.employee_view
AS SELECT employee.ssn, employee.fname, employee.minit,
employee.lname, employee.address,, employee.salary,
employee.superssn, employee.dno FROM employee;

The SQL alter view tool generates the DDL for the view in a database specific way. It is aware of the differences in view creation for the various databases.

The following are links to information about the Alter View tool for some of the databases supported by RazorSQL:

DB2 Alter View
Derby Alter View
Firebird Alter View
HSQLDB Alter View
Informix Alter View
Ingres Alter View
MySQL Alter View
Oracle Alter View
PostgreSQL Alter View
MS SQL Server Alter View
SQLite Alter View
SQL Anywhere Alter View
Sybase Alter View