这两种建立一对一关系,哪种方法好些?
Create table t1
(
fid int identity(1,1) primary key,
f2 int
)
create table t2
(
fid int primary key,
f2 int,
foreign key (fid) references t1(fid)
)
----------------------------------------------
---------------------------------------------------
create table a
( a1 int identity primary key,
a2 int
)
create table b
(a1 int unique foreign key references
a(a1),
a2 int
)