ALTER TABLE [dbo].[Table2] ADD
CONSTRAINT [FK_Table2_Table1] FOREIGN KEY
(
[id]
) REFERENCES [dbo].[Table1] (
[id]
) NOT FOR REPLICATION
GO
CONSTRAINT [FK_Table2_Table1] FOREIGN KEY
(
[id]
) REFERENCES [dbo].[Table1] (
[id]
) NOT FOR REPLICATION
GO
CONSTRAINT [PK_Table1] PRIMARY KEY CLUSTERED
(
[id]
) ON [PRIMARY]
GO
(
SNO varchar(50) not null,
[NAME] varchar(20),
AGE int,
SEX char(1),
CNO varchar(4))
gocreate table c(
cno varchar(4) not null,
major varchar(20)
)alter table c add constraint pk_c primary key clustered(cno)----c表上加主键alter table s
add constraint pk_s primary key clustered(sno) ---s表上加主键
alter table s
add constraint fk_c foreign key (cno)references c (cno)---s表上加外键
谢谢。 还要谢谢 raohui_1978() ,虽然我看不明白,但谢谢你。