ãã
Oracleæ°æ®åºä¸ comment ï¼æ³¨éï¼ ä¿®æ¹æ¹æ³ï¼å两ç§æ
åµï¼ä¸ç§æ¯è¡¨æ³¨éï¼ä¸ç§æ¯å段注éã对表æ表å段å¢å æä¿®æ¹æ³¨éå
容çæ¹æ³é½æ¯ä¸æ ·çã
ããä¸ã表注éä¿®æ¹è¯æ³ï¼
comment on table 表å is '注éå
容';
ããäºãå段注éä¿®æ¹è¯æ³ï¼comment on column 表å.å段å is '注éå
容'ã
ããå¦ï¼
ãã1ãå建表ï¼
ããCREATE TABLE t1(id varchar2(32)
primary key,name VARCHAR2(8) NOT NULL,age number);
ãã2ãæ·»å 表注éï¼
ããComment on table t1 is '个人信æ¯';
ãã3ãæ·»å å段注éï¼
ããcomment on column t1.id is 'id';
ããcomment on column t1.nameis 'å§å';
ããcomment on column t1.age is 'å¹´é¾';