Database Reference
In-Depth Information
ALTER TABLE [dbo].[SSRSObjects]
ADD CONSTRAINT [FK_SSRSObjects_ObjectTypes] FOREIGN KEY([ObjectTypeId])
REFERENCES [dbo].[ObjectTypes] ([ObjectTypeId])
GO
-- Create the FKs to the all the relationship tables --
-- From DWToExcelReportObjects
ALTER TABLE [dbo].[DWToExcelReportObjects]
ADD CONSTRAINT [FK_DWToExcelReportObjects_DWObjects] FOREIGN KEY([DWObjectId])
REFERENCES [dbo].[DWObjects] ([DWObjectId])
GO
ALTER TABLE [dbo].[DWToExcelReportObjects]
ADD CONSTRAINT [FK_DWToExcelReportObjects_ExcelReportObjects] FOREIGN
KEY([ExcelReportObjectId])
REFERENCES [dbo].[ExcelReportObjects] ([ExcelReportObjectId])
GO
-- From DWToSSASObjects
ALTER TABLE [dbo].[DWToSSASObjects]
ADD CONSTRAINT [FK_DWToSSASObjects_DWObjects] FOREIGN KEY([DWObjectId])
REFERENCES [dbo].[DWObjects] ([DWObjectId])
GO
ALTER TABLE [dbo].[DWToSSASObjects]
ADD CONSTRAINT [FK_DWToSSASObjects_SSASObjects] FOREIGN KEY([SSASObjectId])
REFERENCES [dbo].[SSASObjects] ([SSASObjectId])
GO
-- From DWToSSISObjects
ALTER TABLE [dbo].[DWToSSISObjects]
ADD CONSTRAINT [FK_DWToSSISObjects_DWObjects] FOREIGN KEY([DWObjectId])
REFERENCES [dbo].[DWObjects] ([DWObjectId])
GO
ALTER TABLE [dbo].[DWToSSISObjects]
ADD CONSTRAINT [FK_DWToSSISObjects_SSISObjects] FOREIGN KEY([SSIDObjectID])
REFERENCES [dbo].[SSISObjects] ([SSISObjectId])
GO
-- From DWtoSSRSObjects
ALTER TABLE [dbo].[DWtoSSRSObjects]
ADD CONSTRAINT [FK_DWtoSSRSObjects_DWObjects] FOREIGN KEY([DWObjectId])
REFERENCES [dbo].[DWObjects] ([DWObjectId])
GO
ALTER TABLE [dbo].[DWtoSSRSObjects]
ADD CONSTRAINT [FK_DWtoSSRSObjects_SSRSObjects] FOREIGN KEY([SSRSObjectId])
REFERENCES [dbo].[SSRSObjects] ([SSRSObjectId])
GO
-- From SSASToSSRSObjects
ALTER TABLE [dbo].[SSASToSSRSObjects]
ADD CONSTRAINT [FK_SSASToSSRSObjects_SSASObjects] FOREIGN KEY([SSASObjectId])
REFERENCES [dbo].[SSASObjects] ([SSASObjectId])
GO
