17.10 - Example: SHOW VIEW - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Syntax and Examples

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1144-171K
Language
English (United States)

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, sex, dob) AS
       SELECT employee.empno, name, jobtitle, deptno, sex, 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, sex, dob) AS
     SELECT employee.empno, name, jobtitle, deptno, sex, dob 
     FROM employee
     WHERE jobtitle NOT IN ('Vice Pres', 'Manager') 
     WITH CHECK OPTION;