I'm trying to add a comment whithin the CREATE TABLE ddl. I've check that Teradata supports comments via statements of the type:
COMMENT ON COLUMN table.col 'A comment!'
but the problem is SQL Assistand doesn't "visualize" them when I get the table ddl from the "Show Definition" menu.
My question is there a tricky way to add such comments to columns/tables, so they stay bounded to the table DDL?!
Something like the MySQL comment clause:
CREATE TABLE test(
id INT COMMENT 'This is the ID!'
if you just need it in the query then use double hypen to put comments
int a --value of a
,int b -- value of b
But make sure, the comma has to be on the next line :-). .
How can I query the table/column comments? Would like a query for tables & columns: schema, table, column, comments and schema, table comments.