Add comment to a column : comment « Table « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. Table
3. comment

SQL>
SQL> create table salgrades
  2  ( grade      NUMBER(2)
  3  , lowerlimit NUMBER(6,2)
  4  , upperlimit NUMBER(6,2)
  5  , bonus      NUMBER(6,2)
  6  ) ;

Table created.

SQL>
SQL>
SQL> comment on column salgrades.lowerlimit
  2  is     'For sales reps only';

Comment created.

SQL>
SQL> drop table salgrades;

Table dropped.

SQL>