create table BBSUsers
(
UID int, 主键
UName char(20),
UPassword char(30),
UEmail char(50),
UBirthday datetime,
USex bit,
UClass int,
UStatement varchar(100),
URegDate datetime,
UState datetime,
UPoint int
)
create table BBSTopic
(
TID int, 主键
TSID int,
TUID int,
TReplyCount int,
TEmotion char(10),
TTopic varchar(40),
TContents Text,
TTime datetime,
TClickCount int,
TLastClickT datetime
)
这样连接错在哪里
alter table BBSUsers
add constraint fk_BBSTopic_UID
foreign key (UID) references BBSTopic(TUID);
ALTER TABLE [dbo].[外键表] WITH CHECK ADD CONSTRAINT [FK_外键键名]
FOREIGN KEY([外键字段]) REFERENCES [dbo].[主键表] ([主键字段])
你的外键表应该是BBSTopic,主键表是BBSUsers
FOREIGN KEY([外键字段]) REFERENCES [dbo].[主键表] ([主键字段])
你的外键表应该是BBSTopic,主键表是BBSUsers
温馨提示:答案为网友推荐,仅供参考
第1个回答 2012-09-06
ALTER TABLE BBSTopic WITH CHECK ADD CONSTRAINT fk_BBSTopic_UID
FOREIGN KEY(TUID) REFERENCES BBSUsers (UID)
FOREIGN KEY(TUID) REFERENCES BBSUsers (UID)