show create view [视图名];
show table status where comment='view';
desc [视图名];
select * from information_schema.tables where table_schema=[数据库名] and table_type='view';
show create view [视图名];
show table status where comment='view';
desc [视图名];
select * from information_schema.tables where table_schema=[数据库名] and table_type='view';