SQL
>
?
create
?
table
?t?(id?
number
?
primary
?
key
);
?表已創(chuàng)建。
?SQL
>
?
create
?
table
?t1?(id?
number
,?tid?
number
,?
constraint
?fk_t1_t_id?
foreign
?
key
?(tid)
??
?
references
?t?(id));?表已創(chuàng)建。
?SQL
>
?
insert
?
into
?t?
values
?(
1
);
?已創(chuàng)建?
1
?行。
?SQL
>
?
insert
?
into
?t1?
values
?(
1
,?
1
);
?已創(chuàng)建?
1
?行。
?SQL
>
?
commit
;
?提交完成。
?SQL
>
?
delete
?t;
delete
?t
*
ERROR?位于第?
1
?行:ORA
-
02292
:?違反完整約束條件?(YANGTK.FK_T1_T_ID)?
-
?已找到子記錄日志
SQL
>
?
alter
?
table
?t1?
drop
?
constraint
?fk_t1_t_id;?表已更改。
?SQL
>
?
alter
?
table
?t1?
add
?
constraint
?fk_t1_t_id?
foreign
?
key
?(tid)?
references
?t?(id)?
on
?
delete
?
cascade
;
表已更改。?SQL
>
?
delete
?t;
?已刪除?
1
?行。
?SQL
>
?
select
?
*
?
from
?t;
?未選定行
?SQL
>
?
select
?
*
?
from
?t1;
?未選定行
?SQL
>
drop
?
table
?T_ES_Equipment?
cascade
?constraints;
drop
?
table
?T_ES_AnalysisTestCenter?
cascade
?constraints;
create
?
table
?T_ES_AnalysisTestCenter?(
????id?
varchar2
(
32
)?
not
?
null
,
????brief_introduction?
varchar2
(
255
),
????analysis_test_center_name?
varchar2
(
50
),
????remark?
varchar2
(
255
),
????
primary
?
key
?(id)
);
create
?
table
?T_ES_Equipment?(
????id?
varchar2
(
32
)?
not
?
null
,
????school_id?
varchar2
(
255
),
????upload_time?date,
????equip_id?
varchar2
(
50
),
????accessories?
varchar2
(
3255
),
????alias?
varchar2
(
50
),
????application?
varchar2
(
3255
),
????certificate?
varchar2
(
50
),
????CHNNAME?
varchar2
(
100
),
????classification?
varchar2
(
50
),
????ENGNAME?
varchar2
(
100
),
????analysis_test_center_id?
varchar2
(
32
),
????
primary
?
key
?(id)
);
alter
?
table
?T_ES_Equipment?
????
add
?
constraint
?FK57481928D651B652?
????
foreign
?
key
?(analysis_test_center_id)?
????
references
?T_ES_AnalysisTestCenter;