黄松平.txt

来自「关于oracle和sql的书籍和ppt教程,非常好,本人珍藏品」· 文本 代码 · 共 14 行

1
create table hsp_goods(id int,gname varchar2(20),typeid int);

create table hsp_types(id int,typename varchar2(20));

alter table hsp_goods add constraint pk_hsp_goods_id primay key (id);

alter table hsp_types add constraint pk_hsp_types_id primary key (id);

alter table hsp_goods add constraint for_hsp__typeid_to_types_id foreign key (typeid) references hsp_types (id);

alter table hsp_goods modify gname not null;

alter table hsp_types add constraint typename_uniq unique (typename);