mysql查看某个数据库下的所有视图

select TABLE_SCHEMA , TABLE_NAME from information_schema.TABLES where table_type=‘view‘ and TABLE_SCHEMA =‘yw_plm‘;