It is nice to have a `SHOW VIEWS` command similar to Hive (https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL#LanguageManualDDL-ShowViews).
Although this is adding a new feature, this resolved the regression bug in the below.
According to the report, https://github.com/apache/spark/pull/27897#issuecomment-602519201,
Tableau and PowerBI, which use the Simba ODBC driver, do not work with Spark 3.0 with Hive 2.3.
When we switch to Hive 2.3 profile, Simba driver assumes that SHOW VIEWS is supported, and issues it, failing the SQLGetTables call when it fails.