select TABLE_NAME from INFORMATION_SCHEMA.TABLES 这样视图也会被查询出来
select * from INFORMATION_SCHEMA.TABLES
select TABLE_NAME from INFORMATION_SCHEMA.TABLES where TABLE_TYPE=‘base table‘ 这样视图不会被查询出来
原文:https://www.cnblogs.com/jiangyunfeng/p/10587590.html