View A Column's Comments

Create Table Of Superheroes With Comments

Column comments concern a particular column, while table comments are about the entire table.

-- Create a table called SUPERHEROES. If it already exists, replace it.
CREATE OR REPLACE TABLE SUPERHEROES (
  -- Column called ID allowing up to five characters with a comment.
  "ID" VARCHAR (5) COMMENT 'A unique ID for each superhero.', 
  -- Column called ALTER_EGO allowing up to 100 characters with a comment.
  "ALTER_EGO" VARCHAR(100) COMMENT 'The superhero\'s pseudonym.'
) 
-- A comment for the entire table.
COMMENT='A table to superheroes.'
;

Describe The Table

-- Describe the table SUPERHEROES
DESCRIBE TABLE SUPERHEROES;

View Table Comments

-- Select the "name" and "comment" columns
SELECT "name", "comment" 
-- Of the last query (in this case the DESCRIBE TABLE query)
FROM TABLE(RESULT_SCAN(LAST_QUERY_ID()))
;
name comment
ID A unique ID for each superhero.
ALTER_EGO The superhero’s pseudonym.