Bug #72111 Show View
Submitted: 24 Mar 2014 16:42 Modified: 19 Nov 2015 16:00
Reporter: arasu b (OCA) Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Information schema Severity:S4 (Feature request)
Version:ALL OS:Any
Assigned to: CPU Architecture:Any
Tags: VIEW

[24 Mar 2014 16:42] arasu b 
Description:
"Show View"  Feature is not available

To get all the views in a database currently one have to use 

"SHOW FULL TABLES IN database_name WHERE TABLE_TYPE LIKE 'VIEW';"

where as for tables it's "Show tables" and for the database its "show database"

"Show View" command request is a simple alias of the above command to get the list of views under a database.

How to repeat:
This is a feature request. creating an alias for the command

"SHOW FULL TABLES IN database_name WHERE TABLE_TYPE LIKE 'VIEW';"

Suggested fix:
Need to create a alias command show view
[19 Nov 2015 16:00] Georgi Kodinov 
thank you for the reasonable feature request.