View A Table'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 superheroe\'s pseudonym.'
) 
-- A comment for the entire table.
COMMENT='A table for superheroes.'
;

View Table Metadata

-- Show the metadata on all tables called SUPERHEROES
SHOW TABLES LIKE 'SUPERHEROES';

View Table’s Comments

-- Select the "name" and "comment" columns
SELECT "name", "comment" 
-- Of the last query (in this case the SHOW TABLES LIKE 'SUPERHEROES query)
FROM TABLE(RESULT_SCAN(LAST_QUERY_ID()))
;
name comment
SUPERHEROES A table to superheroes.