MySql comments for the columns of a view?

According to the create view syntax there is no way currently to add comments to the "columns" of a view even if the columns of a view are present in the information_schema.columns table:

http://dev.mysql.com/doc/refman/5.0/en/create-view.html


I don't think you can add comments to the view "columns", but you can use the view to retrieve comments from the underlying table, use SHOW COLUMNS as you would when querying a table.


Mysql has no metadata for view columns:

http://dev.mysql.com/doc/refman/5.0/en/views-table.html

So answer is NO.

Tags:

Mysql