COMMENT ON TABLE table_name IS 'A table comment'; COMMENT ON COLUMN table_name.MY_COLUMN IS 'A column comment'; SELECT * FROM ALL_TAB_COMMENTS WHERE TABLE_NAME = 'TABLE_NAME'; SELECT * FROM ALL_COL_COMMENTS WHERE TABLE_NAME = 'TABLE_NAME';