SHOW VIEW

Description

This statement is used to display all views based on the given table

grammar:

SHOW VIEW { FROM | IN } table [ FROM db ]

Examples

1. Show all views created based on table testTbl

   SHOW VIEW FROM testTbl;

Keywords

SHOW, VIEW