首页 > 代码库 > SQL 创建联合主键Table

SQL 创建联合主键Table

CREATE TABLE [User_Instance](    [IntanceID] [int] NOT NULL,    [StaffID] [char](10) NOT NULL) ON [PRIMARY]GOSET ANSI_PADDING OFFGOALTER TABLE [[User_Instance] WITH NOCHECK ADD     CONSTRAINT [PK_User_Instance] PRIMARY KEY  NONCLUSTERED      (          IntanceID,          StaffID     )