Bug #64045 create a comment on a view

Submitted: 17 Jan 2012 9:44 Modified: 17 Jan 2012 10:19
Reporter: elzo valugi Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Information schema Severity:S4 (Feature request)
Version:5.6 OS:Any
Assigned to: CPU Architecture:Any
Tags: comment, VIEW

[17 Jan 2012 9:44] elzo valugi
Description:
CREATE view does not have a COMMENT option like regular tables have although the information schema provides one. The comment is not needed as the type can be retrieved from [TABLE_TYPE] => VIEW, thus duplicating the info.

How to repeat:
SELECT * 
FROM information_schema.tables
WHERE
TABLE_TYPE =  'VIEW'
LIMIT 0 , 30

Shows a TABLE_COMMENT field but it cannot be modified from the default value "VIEW"

Suggested fix:
Alter the CREATE OR REPLACE to include a COMMENT option.
[17 Jan 2012 10:19] Valeriy Kravchuk
Thank you for the feature request.
[7 Jul 2012 19:02] Pavel Bazanov
Guys, it's been almost 10 years since the first request for this feature.
Is it really so difficult to implement?
[7 Jul 2012 19:03] Pavel Bazanov
(Subscribed to updates on this bug report)
[20 Apr 2016 18:06] Paul Chambless
Yes, please implement.  this affects me and my documentation.
[1 Jun 2016 16:34] bennie balandran
It would be nice to have this features. As a DBA, I'm being asked to generate many views and adding comments would be beneficial to many users to have access to our databases,
[6 Jul 2017 22:52] Bruno Aquino Filardi Filho
Please put this feature! Anyone working on this?
[20 Jul 2017 11:11] Paolo Puddu
Allowing comments to views would prevent me having to have maintain separate documentation for explaining some of the calculated fields I am producing in the view.
I would appreciate this feature being added.
Thanks
[18 Dec 2018 12:53] Serg Gin
I'm also need possibility to document my view just in place!
[2 Aug 2023 10:02] Sébastien F.
It would be appreciated :)

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.041 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.