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 for superheroes.' ;