SQL 语句来创建表主键外键

---

你在设计表的界面里加了, 然后生成SQL脚本就可以了

---

ALTER TABLE [dbo].[BookNote] ADD CONSTRAINT [PK_BOOKNOTE] PRIMARY KEY([bookNoteId])
ALTER TABLE [dbo].[BookNote] WITH CHECK ADD CONSTRAINT [FK_BOOKNOTE_记录预订车票_TICKET] FOREIGN KEY([ticketId])
REFERENCES [dbo].[Ticket] ([ticketId])

---

create table 班歼扮级芹圆简况
(班级代号 Char(5) primary key,
班氏首灶级名称 Varchar(12) foreign key)

---

alter table myTest add constraint PK_myTest22 primary key(aa)
alter table myTest add constraint fk_myTest22 foreign key(bb) references test
这个就不错

---

alter table myTest add constraint PK_myTest22 primary key(aa)
alter table myTest add constraint fk_myTest22 foreign key(bb) references test

---