Question

SQL 语句来创建表主键外键

Answer 1

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

Answer 2

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])

Answer 3

create table 班级简况
(班级代号 Char(5) primary key,
班级名称 Varchar(12) foreign key)

Answer 4

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

Answer 5

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