Skip to main content
Get StartedConsole GuideWork With DataRelease NotesReference
Resources
VeloDB Cloud 26.x·Apache Doris 4.x (up to 4.0 supported)·"Since X.Y" tags refer to Apache Doris versionsVersion mapping

SHOW VIEW

Description​

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

Syntax​

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

Example​

  1. Show all views created based on table testTbl

    SHOW VIEW FROM testTbl;

Keywords​

SHOW, VIEW