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;