22,206
社区成员
发帖
与我相关
我的任务
分享
CREATE TABLE [dbo].[TableA](
[TA] [int] NOT NULL,
[TAName] [varchar](10) NULL,
CONSTRAINT [TableA_PK] PRIMARY KEY CLUSTERED
(
[TA] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[TableB](
[TB] [int] NOT NULL,
[TBName] [varchar](10) NULL,
CONSTRAINT [TableB_PK] PRIMARY KEY CLUSTERED
(
[TB] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[TableC](
[TC] [int] NOT NULL,
[TCName] [varchar](10) NULL,
CONSTRAINT [TableC_PK] PRIMARY KEY CLUSTERED
(
[TC] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[TableD](
[TD] [int] NOT NULL,
[TDName] [varchar](10) NULL,
[TC] [int] NULL,
[TA] [int] NULL,
[TE] [int] NULL,
CONSTRAINT [TableD_PK] PRIMARY KEY CLUSTERED
(
[TD] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[TableE](
[TE] [int] NOT NULL,
[TEName] [varchar](10) NULL,
[TA] [int] NULL,
[TB] [int] NULL,
[TC] [int] NULL,
CONSTRAINT [TableE_PK] PRIMARY KEY CLUSTERED
(
[TE] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[TableF](
[TF] [int] NOT NULL,
[TFName] [varchar](10) NULL,
[TD] [int] NULL,
[TE] [int] NULL,
[TC] [int] NULL,
[TB] [int] NULL,
[TA] [int] NULL,
CONSTRAINT [TableF_PK] PRIMARY KEY CLUSTERED
(
[TF] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[TableD] WITH CHECK ADD CONSTRAINT [TableA_TableD_FK1] FOREIGN KEY([TA])
REFERENCES [dbo].[TableA] ([TA])
GO
ALTER TABLE [dbo].[TableD] CHECK CONSTRAINT [TableA_TableD_FK1]
GO
ALTER TABLE [dbo].[TableD] WITH CHECK ADD CONSTRAINT [TableC_TableD_FK1] FOREIGN KEY([TC])
REFERENCES [dbo].[TableC] ([TC])
GO
ALTER TABLE [dbo].[TableD] CHECK CONSTRAINT [TableC_TableD_FK1]
GO
ALTER TABLE [dbo].[TableD] WITH CHECK ADD CONSTRAINT [TableE_TableD_FK1] FOREIGN KEY([TE])
REFERENCES [dbo].[TableE] ([TE])
GO
ALTER TABLE [dbo].[TableD] CHECK CONSTRAINT [TableE_TableD_FK1]
GO
ALTER TABLE [dbo].[TableE] WITH CHECK ADD CONSTRAINT [TableA_TableE_FK1] FOREIGN KEY([TA])
REFERENCES [dbo].[TableA] ([TA])
GO
ALTER TABLE [dbo].[TableE] CHECK CONSTRAINT [TableA_TableE_FK1]
GO
ALTER TABLE [dbo].[TableE] WITH CHECK ADD CONSTRAINT [TableB_TableE_FK1] FOREIGN KEY([TB])
REFERENCES [dbo].[TableB] ([TB])
GO
ALTER TABLE [dbo].[TableE] CHECK CONSTRAINT [TableB_TableE_FK1]
GO
ALTER TABLE [dbo].[TableE] WITH CHECK ADD CONSTRAINT [TableC_TableE_FK1] FOREIGN KEY([TC])
REFERENCES [dbo].[TableC] ([TC])
GO
ALTER TABLE [dbo].[TableE] CHECK CONSTRAINT [TableC_TableE_FK1]
GO
ALTER TABLE [dbo].[TableF] WITH CHECK ADD CONSTRAINT [TableA_TableF_FK1] FOREIGN KEY([TA])
REFERENCES [dbo].[TableA] ([TA])
GO
ALTER TABLE [dbo].[TableF] CHECK CONSTRAINT [TableA_TableF_FK1]
GO
ALTER TABLE [dbo].[TableF] WITH CHECK ADD CONSTRAINT [TableB_TableF_FK1] FOREIGN KEY([TB])
REFERENCES [dbo].[TableB] ([TB])
GO
ALTER TABLE [dbo].[TableF] CHECK CONSTRAINT [TableB_TableF_FK1]
GO
ALTER TABLE [dbo].[TableF] WITH CHECK ADD CONSTRAINT [TableC_TableF_FK1] FOREIGN KEY([TC])
REFERENCES [dbo].[TableC] ([TC])
GO
ALTER TABLE [dbo].[TableF] CHECK CONSTRAINT [TableC_TableF_FK1]
GO
ALTER TABLE [dbo].[TableF] WITH CHECK ADD CONSTRAINT [TableD_TableF_FK1] FOREIGN KEY([TD])
REFERENCES [dbo].[TableD] ([TD])
GO
ALTER TABLE [dbo].[TableF] CHECK CONSTRAINT [TableD_TableF_FK1]
GO
ALTER TABLE [dbo].[TableF] WITH CHECK ADD CONSTRAINT [TableE_TableF_FK1] FOREIGN KEY([TE])
REFERENCES [dbo].[TableE] ([TE])
GO
ALTER TABLE [dbo].[TableF] CHECK CONSTRAINT [TableE_TableF_FK1]
GO
INSERT [dbo].[TableA] ([TA], [TAName]) VALUES (1, N'A1')
GO
INSERT [dbo].[TableA] ([TA], [TAName]) VALUES (2, N'A2')
GO
INSERT [dbo].[TableA] ([TA], [TAName]) VALUES (3, N'A3')
GO
INSERT [dbo].[TableC] ([TC], [TCName]) VALUES (1, N'C1')
GO
INSERT [dbo].[TableC] ([TC], [TCName]) VALUES (2, N'C2')
GO
INSERT [dbo].[TableC] ([TC], [TCName]) VALUES (3, N'C3')
GO
INSERT [dbo].[TableB] ([TB], [TBName]) VALUES (1, N'B1')
GO
INSERT [dbo].[TableB] ([TB], [TBName]) VALUES (2, N'B2')
GO
INSERT [dbo].[TableB] ([TB], [TBName]) VALUES (3, N'B3')
GO
INSERT [dbo].[TableE] ([TE], [TEName], [TA], [TB], [TC]) VALUES (1, N'E1', 1, 1, 1)
GO
INSERT [dbo].[TableE] ([TE], [TEName], [TA], [TB], [TC]) VALUES (2, N'E2', 2, 2, 2)
GO
INSERT [dbo].[TableE] ([TE], [TEName], [TA], [TB], [TC]) VALUES (3, N'E3', 3, 3, 3)
GO
INSERT [dbo].[TableD] ([TD], [TDName], [TC], [TA], [TE]) VALUES (1, N'D1', 1, 1, 1)
GO
INSERT [dbo].[TableD] ([TD], [TDName], [TC], [TA], [TE]) VALUES (2, N'D2', 2, 2, 2)
GO
INSERT [dbo].[TableD] ([TD], [TDName], [TC], [TA], [TE]) VALUES (3, N'D3', 3, 3, 3)
GO
INSERT [dbo].[TableF] ([TF], [TFName], [TD], [TE], [TC], [TB], [TA]) VALUES (1, N'F1', 1, 1, 1, 1, 1)
GO
INSERT [dbo].[TableF] ([TF], [TFName], [TD], [TE], [TC], [TB], [TA]) VALUES (2, N'F2', 2, 2, 2, 2, 2)
GO
INSERT [dbo].[TableF] ([TF], [TFName], [TD], [TE], [TC], [TB], [TA]) VALUES (3, N'F3', 3, 3, 3, 3, 3)
GO