Table Comment missing

[richard_chilvers]

I like to use 'COMMENT TABLE WITH' as a way to clarify the content and structure of a table, especially when it has been LOADed from several sources or in a specific way.

Eg. COMMENT TABLE Main WITH 'This is the Main table of data';

This works well, but what is the syntax for the comment string? I have just added a long comment over several lines, which did not cause a script error, but has not appeared with the table.

Any ideas?

Thanks

[richard_chilvers]

Thanks.

I have found out the hard way that spelling is important, because a mis-spelt table name doesn't give an error.

I will check my spell once more