MySQL 뷰 목록 조회

개요

How to get a list of MySQL views

MySQL 뷰 목록 조회

방법 1: SHOW FULL TABLES

SHOW FULL TABLES IN 디비명
WHERE TABLE_TYPE LIKE 'VIEW';

mysql> SHOW FULL TABLES IN mydb1 WHERE TABLE_TYPE LIKE 'VIEW';
+-----------------+------------+
| Tables_in_mydb1 | Table_type |
+-----------------+------------+
| myview1         | VIEW       |
| myview2         | VIEW       |
+-----------------+------------+
2 row in set (0.00 sec)

방법 2: information_schema

SELECT TABLE_NAME
FROM information_schema.`TABLES`
WHERE TABLE_TYPE LIKE 'VIEW'
AND TABLE_SCHEMA LIKE '디비명';

mysql> SELECT TABLE_NAME FROM information_schema.`TABLES` WHERE TABLE_TYPE LIKE 'VIEW' AND TABLE_SCHEMA LIKE 'mydb1';
+------------+
| TABLE_NAME |
+------------+
| myview1    |
| myview2    |
+------------+
2 row in set (0.00 sec)

같이 보기

• MySQL SHOW FULL TABLES
• MySQL 뷰 생성 쿼리 보기 SHOW CREATE VIEW
• MySQL 테이블 목록 조회 SHOW TABLES
• MySQL information_schema.TABLES
• 뷰

참고

• http://stackoverflow.com/questions/2834016/how-to-get-a-list-of-mysql-views