查看和删除视图

#3.删除视图
/*
语法：
drop view 视图名,视图名,...;
*/

DROP VIEW myv1,myv2,myv3;
#四、查看视图
CREATE OR REPLACE VIEW myv3
AS
SELECT AVG(salary),job_id
FROM employees
GROUP BY job_id;
DESC myv3;