【SQL开源代码栏目提醒】:网学会员为广大网友收集整理了,Foreign.sql,希望对大家有所帮助!
Create Table sm_BasicInfo
(
stu_ID Number Constraint sm_BIPK Primary Key,
stu_Name Varchar(10) not null,
stu_Sex Varchar(1) Constraint sm_CHK Check(stu_Sex in ('M', 'F'))
);
Create Table sm_History
(
stu_HID Number Constraint sm_HPK Primary Key,
stu_ID Number not null,
Constraint sm_FK Foreign Key(stu_ID) References sm_BasicInfo
);
Insert Into sm_History Values(1111, 1001);
Insert Into sm_BasicInfo Values(1001, 'tianen', 'M');
Insert Into sm_History Values(1111, 1001);