How do you add Comment to Columns of a Table

Hello,

I want to know how does one add Comments to Columns of a Table?

I thought it is done this way:

ALTER TABLE compare temp VARCHAR(200) DEFAULT ‘Hello’ COMMENT ‘This is my comment about this column’;

But after I created the above sample Column and did DESCRIBE table, the comment is not after that column! Is there a special DESCRIBE for seeing the comments associated with each Column or does one attach a comment to a column in a diff way?

ThanX.

use SHOW CREATE TABLE instead of DESCRIBE

Thank you :slight_smile: