sqlplus创建表和comment

来源:互联网 发布:北京海星数据 编辑:程序博客网 时间:2024/06/01 09:11

create table t_rush_repair
(
rush_id number not null,
input_name varchar2(50),
linetype number,
linename varchar2(50),
repair_content varchar2(200),
repair_date date,
memo varchar2(200)
);

COMMENT ON COLUMN t_rush_repair.rush_id IS '主键';

COMMENT ON COLUMN t_rush_repair.INPUT_NAME IS '抢修人';

COMMENT ON COLUMN t_rush_repair.LINETYPE IS '管线类型';

COMMENT ON COLUMN t_rush_repair.LINENAME IS '管线名称';

COMMENT ON COLUMN t_rush_repair.REPAIR_CONTENT IS '抢修内容';

COMMENT ON COLUMN t_rush_repair.REPAIR_DATE IS '抢修日期';

COMMENT ON COLUMN t_rush_repair.MEMO IS '备注'; 

原创粉丝点击