it seemed to be the simplest thing: Adding a comment rgd. a specific table to the load script so that later, when hovering above that table in the table_viewer, the comment will be visible. I am using the following syntax:
COMMENT TABLE [table_name] WITH '[my_text]';
It also works with that syntax for one table. For some inexplicable reason, though, when I copied this exact command under the Load_statement for another table (only changing the name of the table), it does not.
Can anybody advise me on any pitfalls this command has?
no, unfortunately it still doesn't work in my case - it's inexplicable to me because I have really copied the exact same statement.
In the case of one table (where I have a perfect key), the comment appears in the table-viewer (it is underneath the Load statement in the script (closed with a semicolon) and it uses the name I have given to the table).
In the case of the second table where I have a perfect key, I have again written (or pasted) the statement underneath the Load statement (properly closed) and inserted the name I have given to the table - and that one doesn't appear in the table-viewer.
Can anybody else think of any reason there might be for this strange behaviour?
