Oracle数据库 表添加新字段,备注,默认值
添加列:
alter table KJGL_SXS add (
JJLXR VARCHAR2(20),
JJLXDH VARCHAR2(20)
);
添加备注:
comment on column KJGL_SXS.JJLXR is '紧急联系人';
comment on column KJGL_SXS.JJLXDH is '紧急联系电话';
添加默认值:
alter table KJGL_SXS modify JJLXR default '测试';