查看视图其实也就是查看视图的结构。视图是一张虚拟表只有结构没有数据的虚拟表，所以表的所有查看方式都适用于视图
一、查看视图字段信息
格式：
desc 视图名称;
或
show columns from 视图名称;
或
describe 视图名称;
示例：
mysql> desc shi;
---------- ------------------ ------ ----- --------- -------
| Field | Type | Null | Key | Default | Extra |
---------- ------------------ ------ ----- --------- -------
| id | int(10) unsigned | NO | | 0 | |
| author | varchar(40) | NO | | NULL | |
| title | varchar(250) | NO | | NULL | |
| datetime | date | YES | | NULL | |
---------- ------------------ ------ ----- --------- -------
4 rows in set (0.00 sec)
mysql> show columns from shi;
---------- ------------------ ------ ----- --------- -------
| Field | Type | Null | Key | Default | Extra |
---------- ------------------ ------ ----- --------- -------
| id | int(10) unsigned | NO | | 0 | |
| author | varchar(40) | NO | | NULL | |
| title | varchar(250) | NO | | NULL | |
| datetime | date | YES | | NULL | |
---------- ------------------ ------ ----- --------- -------
4 rows in set (0.02 sec)
mysql> describe shi;
---------- ------------------ ------ ----- --------- -------
| Field | Type | Null | Key | Default | Extra |
---------- ------------------ ------ ----- --------- -------
| id | int(10) unsigned | NO | | 0 | |
| author | varchar(40) | NO | | NULL | |
| title | varchar(250) | NO | | NULL | |
| datetime | date | YES | | NULL | |
---------- ------------------ ------ ----- --------- -------
4 rows in set (0.00 sec)
show tables [like]/desc 视图名字/sho有一个关键字的区别: view. 查看”表(视图)”的创建语句的时候可以使用view关键字。
二、查看视图表结构信息
因为视图是一张表所以查看视图信息可以使用show create view语句查询也可以使用show create table查询，然而普通表不能用show create view语句查询。
格式：
show create view 视图表名称;
或
show create table 视图表名称;
示例：
mysql> show create view shi;
------ ------------------------------------------------------------------------
--------------------------------------------------------------------------------
------------------------------------------------------------------------------
| View | Create View
|
------ ------------------------------------------------------------------------
--------------------------------------------------------------------------------
------------------------------------------------------------------------------
| shi | CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFI
NER VIEW `shi` AS select `article`.`id` AS `id`,`article`.`author` AS `author`,`
article`.`title` AS `title`,`article`.`datetime` AS `datetime` from `article` |
------ ------------------------------------------------------------------------
--------------------------------------------------------------------------------
------------------------------------------------------------------------------
示例：
mysql> show create table shi;
------ ------------------------------------------------------------------------
--------------------------------------------------------------------------------
------------------------------------------------------------------------------
| View | Create View
|
------ ------------------------------------------------------------------------
--------------------------------------------------------------------------------
------------------------------------------------------------------------------
| shi | CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFI
NER VIEW `shi` AS select `article`.`id` AS `id`,`article`.`author` AS `author`,`
article`.`title` AS `title`,`article`.`datetime` AS `datetime` from `article` |
------ ------------------------------------------------------------------------
--------------------------------------------------------------------------------
------------------------------------------------------------------------------
1 row in set (0.00 sec)