Mega Code Archive

 

Categories / MySQL Tutorial / Data Dictionary

 

The INFORMATION_SCHEMA VIEWS Table

The VIEWS table provides information about views in databases. You must have the SHOW VIEW privilege to access this table. mysql> desc INFORMATION_SCHEMA.VIEWS; +-----------------+--------------+------+-----+---------+-------+ | Field           | Type         | Null | Key | Default | Extra | +-----------------+--------------+------+-----+---------+-------+ | TABLE_CATALOG   | varchar(512) | YES  |     | NULL    |       | | TABLE_SCHEMA    | varchar(64)  | NO   |     |         |       | | TABLE_NAME      | varchar(64)  | NO   |     |         |       | | VIEW_DEFINITION | longtext     | NO   |     |         |       | | CHECK_OPTION    | varchar(8)   | NO   |     |         |       | | IS_UPDATABLE    | varchar(3)   | NO   |     |         |       | | DEFINER         | varchar(77)  | NO   |     |         |       | | SECURITY_TYPE   | varchar(7)   | NO   |     |         |       | +-----------------+--------------+------+-----+---------+-------+ 8 rows in set (0.02 sec)