Comment on table or column

Oracle December 23rd, 2006

语法:

comment on table table_name is ‘hello table!’;
commnet on view view_name is ‘hello view!’;
comment on column [table|view].column is ‘hello column!’;

例子:

create table HX.HX_PO_CONTRACT_ITEMS (
item_number varchar2(100) not null,
item_THICKNESS number default null,
item_width number default null,
item_LENGTH number default null,
item_HEIGHT number default null,
item_CAIZHI varchar2(100) default null
);

comment on table HX.HX_PO_CONTRACT_ITEMS is ‘XXXX原材料物料编码材质规格对应表’;
comment on column HX.HX_PO_CONTRACT_ITEMS.ITEM_NUMBER is ‘物料编码’;
comment on column HX.HX_PO_CONTRACT_ITEMS.ITEM_THICKNESS is ‘厚度’;
comment on column HX.HX_PO_CONTRACT_ITEMS.ITEM_WIDTH is ‘宽度’;
comment on column HX.HX_PO_CONTRACT_ITEMS.ITEM_LENGTH is ‘长度’;
comment on column HX.HX_PO_CONTRACT_ITEMS.ITEM_HEIGHT is ‘高度’;
comment on column HX.HX_PO_CONTRACT_ITEMS.ITEM_CAIZHI is ‘材质’;

Image Hosted by ImageShack.us

3 Responses to “Comment on table or column”

  1. ohr Says:

    good example

  2. Enkwean.Chow Says:

    看了你的文章,共振很厉害

  3. Enkwean.Chow Says:

    我说的是生活和工作隔离带
    Not this one

Leave a Reply