{ “title”: “SHOW-VIEW”, “language”: “en” }

SHOW-VIEW

Name

SHOW VIEW

Description

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

grammar:

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

Example

  1. Show all views created based on table testTbl

    SHOW VIEW FROM testTbl;
    

Keywords

SHOW, VIEW

Best Practice