Xem định nghĩa View MySQL bằng SHOW CREATE VIEW

Dùng SHOW CREATE VIEW để xem định nghĩa view, tương tự SHOW CREATE TABLE.

Cú pháp

SHOW CREATE VIEW view_name;

Ví dụ

Xem định nghĩa view info:

mysql> Show Create View Info\G
*************************** 1. row ***************************
  View: info
  Create View: CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `info` AS select `student_info`.`id` AS `ID`, `student_info`.`Name` AS `NAME`, `student_info`.`Subject` AS `SUBJECT`, `student_info`.`Address` AS `ADDRESS` from `student_info`
  character_set_client: cp850
  collation_connection: cp850_general_ci
1 row in set (0.00 sec)