# RazorSQL

## Query, Edit, Browse, and Manage Databases

- razorsql.com
- Contact

# MySQL Alter View

The MySQL 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 sample.employee_view
CREATE VIEW sample.employee_view (ssn,fname,minit,lname,address,sex,salary,superssn,dno) AS
/* ALGORITHM=UNDEFINED */
select `sample`.`employee`.`ssn` AS `ssn`,`sample`.`employee`.`fname` AS `fname`,`sample`.`employee`.`minit` AS `minit`,`sample`.`employee`.`lname` AS `lname`,`sample`.`employee`.`address` AS `address`,`sample`.`employee`.`sex` AS `sex`,`sample`.`employee`.`salary` AS `salary`,`sample`.`employee`.`superssn` AS `superssn`,`sample`.`employee`.`dno` AS `dno` from `sample`.`employee`