复制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 ) 被引用的键必须***，b2b供应网可以设置为主键或者添加***约束。云服务器提供商写法键建 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]) 1.2.3.4.5.6.7.8.9.10.11.12.13.14.15.16.17.18.19.20.21.22.23.24.25.26.云服务器 |
喜欢
讨厌