text: -- Test data.
  CREATE DATABASE showdb;
  USE showdb;
  CREATE TABLE show_t1(a String, b Int) PARTITIONED BY (c String, d String);
  ALTER TABLE show_t1 ADD PARTITION (c='Us', d=1);
  CREATE TABLE show_t2(b String, d Int);
  CREATE TEMPORARY VIEW show_t3(e int) USING parquet;
  CREATE GLOBAL TEMP VIEW show_t4 AS SELECT 1 as col1;
  
  -- SHOW TABLES
  SHOW TABLES;
  SHOW TABLES IN showdb;
  
  -- SHOW TABLES WITH wildcard match
  SHOW TABLES 'show_t*';
  SHOW TABLES LIKE 'show_t1*|show_t2*';
  SHOW TABLES IN showdb 'show_t*';
  
  -- SHOW TABLE EXTENDED
  -- Ignore these because there exist timestamp results, e.g. `Created`.
  -- SHOW TABLE EXTENDED LIKE 'show_t*';
  SHOW TABLE EXTENDED;
  SHOW TABLE EXTENDED LIKE 'show_t1' PARTITION(c='Us');
  
  -- Clean Up
  DROP TABLE show_t1;
  DROP TABLE show_t2;
  DROP VIEW  show_t3;
  DROP VIEW  global_temp.show_t4;
  USE default;
  DROP DATABASE showdb;
  