Description:
SHOW TABLE STATUS shows "view" in lower case.
You (inconsistently) use upper case "VIEW" for SHOW TABLES
because the standard says use "VIEW" for metadata
tables e.g. in INFORMATION_SCHEMA. So "VIEW" is
probably better here too.
How to repeat:
mysql> create view v as select 'a';
Query OK, 0 rows affected (0.00 sec)
mysql> show table status;
+------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+-------------+-------------+------------+-----------+----------+----------------+---------+
| Name | Engine | Version | Row_format | Rows | Avg_row_length | Data_length |
Max_data_length | Index_length | Data_free | Auto_increment | Create_time | Update_time |
Check_time | Collation | Checksum | Create_options | Comment |
+------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+-------------+-------------+------------+-----------+----------+----------------+---------+
| v | NULL | NULL | NULL | NULL | NULL | NULL |
NULL |
NULL | NULL | NULL | NULL | NULL | NULL | NULL |
NULL |
NULL | view |
+------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+-------------+-------------+------------+-----------+----------+----------------+---------+
1 row in set (0.00 sec)
