--主表语句
CREATE TABLE ZDJS.crd_main_tab
(
ID_ VARCHAR2(128) NOT NULL ENABLE,
STATION_NAME_ VARCHAR2(128),
CREATE_TIME_ DATE,
CHECK (ID_ IS NOT NULL) ENABLE,
PRIMARY KEY (ID_)
) ;
COMMENT ON COLUMN ZDJS.crd_main_tab.ID_ IS ‘ID‘;
COMMENT ON COLUMN ZDJS.crd_main_tab.STATION_NAME_ IS ‘所属站名‘;
COMMENT ON COLUMN ZDJS.crd_main_tab.CREATE_TIME_ IS ‘创建时间‘;
COMMENT ON TABLE ZDJS.crd_main_tab IS ‘crd测试主表‘;
--子表语句
CREATE TABLE ZDJS.crd_sub_tab
(
ID_ VARCHAR2(128) PRIMARY KEY NOT NULL ENABLE,
refid_ varchar2(128),
STATION_NAME_ VARCHAR2(128),
CREATE_TIME_ DATE,
constraint mySubRef foreign key(refid_) references ZDJS.crd_main_tab(ID_)
);
COMMENT ON COLUMN ZDJS.crd_sub_tab.ID_ IS ‘ID‘;
COMMENT ON COLUMN ZDJS.crd_sub_tab.refid_ IS ‘ID‘;
COMMENT ON COLUMN ZDJS.crd_sub_tab.STATION_NAME_ IS ‘所属站名‘;
COMMENT ON COLUMN ZDJS.crd_sub_tab.CREATE_TIME_ IS ‘创建时间‘;
COMMENT ON TABLE ZDJS.crd_sub_tab IS ‘crd测试子表‘;
--alter table ZDJS.crd_sub_tab add constraint mySubRef foreign key(refid_) referencesZDJS.crd_main_tab(ID_);
--drop table ZDJS.crd_sub_tab
原文：https://www.cnblogs.com/rdchen/p/12360972.html
如果您也喜欢它,动动您的小指点个赞吧
602392714
清零编程群