COMMENT

Syntax

COMMENT ON TABLE name IS 'comments'

Description

This statement is used to set the comment information of a table. You can delete the comment by setting the comment information to NULL.

Example

Change the comment of the users table to "master table". You can run the show create table tablename statement to view the comment.

COMMENT ON TABLE users IS 'master table';