Add Comment To Column

Create Table Of Superheroes

-- Create a table called SUPERHEROES. If it already exists, replace it.
CREATE OR REPLACE TABLE SUPERHEROES (
  -- Column called ID allowing up to five characters
  "ID" VARCHAR(5), 
  -- Column called NAME allowing up to 100 characters
  "NAME" VARCHAR(100),
  -- Column called ALTER_EGO allowing up to 100 characters
  "ALTER_EGO" VARCHAR(100)
);

Insert Rows For Each Superhero

-- Insert rows into SUPERHEROES
INSERT INTO SUPERHEROES 
    -- With the values
    VALUES
    ('XF6K4', 'Chris Maki', 'The Bomber'),
    ('KD5SK', 'Donny Mav', 'Nuke Miner');

Describe Table (To See Comments)

-- Describe table
DESCRIBE TABLE SUPERHEROES;
name type kind null? default primary key unique key check expression comment
ID VARCHAR(5) COLUMN Y N N
NAME VARCHAR(100) COLUMN Y N N
ALTER_EGO VARCHAR(100) COLUMN Y N N

Add Comment To Column

Note: If a comment already exists, this will override it.

-- If it exists, comment...
COMMENT IF EXISTS 
-- The "ALTER_EGO" column in the table "SUPERHEROES"
ON COLUMN SUPERHEROES.ALTER_EGO
-- With this string
IS 'This is a column of the superhero aliases';

Describe Table (To See Comments)

-- Describe table
DESCRIBE TABLE SUPERHEROES;
name type kind null? default primary key unique key check expression comment
ID VARCHAR(5) COLUMN Y N N
NAME VARCHAR(100) COLUMN Y N N
ALTER_EGO VARCHAR(100) COLUMN Y N N This is a column of the superhero aliases