MySQL 뷰 목록 조회

1 개요

How to get a list of MySQL views

MySQL 뷰 목록 조회

2 방법 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)

3 방법 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)

4 같이 보기

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

5 참고

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