SHOW CREATE VIEW
语法格式
SHOW CREATE VIEW [database_name.]view_name
说明
这个语句显示地使用CREATE VIEW 创建视图。
示例
显示创建student_v 视图的语句。
gbase> SHOW CREATE VIEW student_v;
+----------+-...-+---------------------------------------------------+-...-+
| View | ... | Create View | ... |
+----------+-...---------------------------------------------------- +-...-+
| student_v | ... | CREATE ... VIEW " student_v "AS select ... from | ... |
+----------+-...-+---------------------------------------------------+-...-+
1 row in set
说明
在显示信息中包含4 列,每列的具体信息如下。
View:student_v
Create View:CREATE ALGORITHM=UNDEFINED DEFINER="root"@"%" SQL
SECURITY DEFINER VIEW "student_v" AS select "student"."stu_no" AS
"stu_no","student"."stu_name" AS "stu_name","student"."stu_sex" AS "stu_sex" from
"student"
character_set_client:utf8
collation_connection:utf8_general_ci