--创建表
create table GROUP_SUPPLIER
(
SUPPLIER_NO VARCHAR2(32) not null,
SUPPLIER_NAME VARCHAR2(64) not null,
UPDATE_TIME DATE
);
comment on table GROUP_SUPPLIER is '供应商信息';
comment on column GROUP_SUPPLIER.SUPPLIER_NO IS '供应商编号';
comment on column GROUP_SUPPLIER.SUPPLIER_NAME IS '供应商名称';
--添加主键
alter table GROUP_SUPPLIER add constraint GROUP_SUPPLIER_SUPPLIER_NO primary key(SUPPLIER_NO);
--表新增字段
alter table GROUP_ACTIVITY
add (GROUP_SUPPLIER VARCHAR2(32));
--添加备注
comment on column GROUP_ACTIVITY.GROUP_SUPPLIER is '适用范围,供应商编号以,分割,全部:-1';