Displays information about views. If you do not specify a wildcard or list of view names, SQL displays the names of all the views in all attached databases. If you do not specify any of the SHOW VIEW options (COLUMNS, COMMENT, or SOURCE), by default you will see the display for all these options. You Specify This: SQL Displays Information About: SOURCE Source definitions for the specified views.