SQL Server 2005 建立外键约束(foreign key)

CREATE TABLE [dbo].[Varrily]

(

[ID] [bigint] NOT NULL ,

[Name] [char] (10) NULL ,

[Address] [char] (480) NULL ,

[Introduction] [ntext] NULL

)

 

CREATE TABLE [dbo].[MyTable]

(

[ID] [bigint] IDENTITY (1, 1) NOT NULL ,

[AuthorID] [bigint] NOT NULL ,

[Title] [char] (40) NULL ,

[Date_of_Created] [datetime] NULL

)

 

被引用的键必须唯一，可以设置为主键或者添加唯一约束。

 

alter table dbo.Varrily add constraint pk_id primary key (ID)

alter table dbo.Varrily add constraint un_id unique (ID)

alter table dbo.MyTable add constraint fk_AuthorID foreign key (AuthorID) references dbo.Varrily([ID])