다음 쿼리의 도움으로 특정 데이터베이스에 저장된 보기 목록을 볼 수 있습니다. 여기서는 'query'라는 데이터베이스를 사용하고 있습니다.
mysql> SELECT TABLE_NAME FROM information_schema.`TABLES` WHERE TABLE_TYPE LIKE'view' AND TABLE_SCHEMA LIKE 'query'; +-----------------------------+ | TABLE_NAME | +-----------------------------+ | customer_view | | first_view | | info | | info_less | | view_detail | | view_student_detail | | view_student_detail_columns | +-----------------------------+ 7 rows in set (0.01 sec) mysql> SHOW FULL TABLES IN query WHERE TABLE_TYPE LIKE 'VIEW'; +-----------------------------+------------+ | Tables_in_query | Table_type | +-----------------------------+------------+ | customer_view | VIEW | | first_view | VIEW | | info | VIEW | | info_less | VIEW | | view_detail | VIEW | | view_student_detail | VIEW | | view_student_detail_columns | VIEW | +-----------------------------+------------+ 7 rows in set (0.01 sec) mysql> SELECT TABLE_SCHEMA, TABLE_NAME -> FROM information_schema.tables -> WHERE TABLE_TYPE LIKE 'VIEW'AND TABLE_SCHEMA = 'query'; +--------------+-----------------------------+ | TABLE_SCHEMA | TABLE_NAME | +--------------+-----------------------------+ | query | customer_view | | query | first_view | | query | info | | query | info_less | | query | view_detail | | query | view_student_detail | | query | view_student_detail_columns | +--------------+-----------------------------+ 7 rows in set (0.05 sec)