我先建表table1:
create table table1(id integer not null primary key,tbname char(64))
而后我建表table2:并创建外键
create table table2(id integer references table1(id),tbname varchar(255))
ci
另一个例子it
建表例子:
create table ltperson(
cuserid varchar(8) primary key,
cpersonname varchar(40) not null,
cpassword varchar(36) not null,
csex varchar(2) not null,
chomepage varchar(80),
cemail varchar(40),
cpassask varchar(40) not null,
cpassanswer varchar(40) not null,
ctpersoncid varchar(8),
cmanager bit,
foreign key (ctpersoncid)
references tperson(cid)
on delete cascade
on update cascade
)table
定了外键,且删除更新级联 email