This example begins with the creation of the view, then progresses to the SHOW VIEW request and finally presents the result of the report request.
CREATE VIEW staff_info (number, name, position, department, gender, dob) AS SELECT employee.empno, name, jobtitle, deptno, gender, dob FROM employee WHERE jobtitle NOT IN ('Vice Pres', 'Manager') WITH CHECK OPTION;
When you submit the following SHOW VIEW request, the database returns the following view definition.
SHOW VIEW staff_info; CREATE VIEW staff_info (number, name, position, department, gender, dob) AS SELECT employee.empno, name, jobtitle, deptno, gender, dob FROM employee WHERE jobtitle NOT IN ('Vice Pres', 'Manager') WITH CHECK OPTION;