SQL数据库无法建立外键的问题

设立外键是关联的另一个表的键必须是主键create table lanmuinfo
(Lan_id varchar(20) not null primary key,
lanname nchar(10)
)create table newsinfo
(news_id int not null primary key,
lanname nchar(10) foreign key references lanmuinfo(lan_id),//如果一定要用lanname，那就把lanname也设为主键
title nchar(10)
)

create table lanmuinfo
(Lan_id int not null primary key,
lanname nchar(10)
)
gocreate table newsinfo
(news_id int not null primary key,
lanname nchar(10) foreign key references lanmuinfo(lanname),
title nchar(10)
)

把这句lanname nchar(10) constraint FK_newsinfo_lanmuinfo foreign key references lanmuinfo(lanname),改成lanname nchar(10) constraint FK_newsinfo_lanmuinfo foreign key references lanmuinfo(Lan_id), 试试