41. SHOW VIEW

SHOW VIEW

Can be used to display the DDL for VIEW which was used to create that particular view

Syntax :

SHOW VIEW <view name>;

Exmaple :

Show view dept;

Results

CREATE VIEW dept

AS

SELECT department_number

,department_name

,budget_amount

,manager_employee_number

FROM customer_service.department

WHERE department_number > 10;