Documenting Your Oracle Data Warehouse

oracle.sql

create table orders (id int);

comment on table orders is 'This table holds all customer orders!';

select comments
from user_tab_comments
where table_name='orders';
┌───────────────────────────────────────┐
│               comments                |
├───────────────────────────────────────┤
│ This table holds all customer orders! │
└───────────────────────────────────────┘