8. SQL Statements : COMMENT ON : COMMENT ON Examples
 
Share this page                  
COMMENT ON Examples
Store comments about a table:
1. Create a comment on the authors table.
COMMENT ON TABLE authors IS
   'It was the best of times, it was the worst
   of times. It was...'
2. Delete comments on the authors table.
COMMENT ON TABLE authors IS '';
3. Comment on column, name, in the authors table.
COMMENT ON COLUMN authors.name IS 'Call me Ishmael';