Create and Manage a View
Create a view. For example, execute the following SQL statement to create a view named v_s, used to query teachers aged over 18:
create view v_s as select name from teachers where age>18;
Check the statement used for creating a view. For example, execute the following SQL statement to check the statement used for creating view v_s:
show create view v_s;
Drop a view. For example, execute the following SQL statement to drop view v_s:
drop view v_s;