Database Reference
In-Depth Information
CREATE TABLE [dbo].[DWToSSASObjects](
[DWObjectId] [int] NOT NULL,
[SSASObjectId] [int] NOT NULL,
CONSTRAINT [PK_DWToSSASObjects] PRIMARY KEY CLUSTERED
( [DWObjectId] ASC, [SSASObjectId] ASC )
)
GO
CREATE TABLE [dbo].[DWToExcelReportObjects](
[DWObjectId] [int] NOT NULL,
[ExcelReportObjectId] [int] NOT NULL,
CONSTRAINT [PK_DWToExcelReportObjects] PRIMARY KEY CLUSTERED
( [DWObjectId] ASC, [ExcelReportObjectId] ASC )
)
GO
CREATE TABLE [dbo].[DWtoSSRSObjects](
[DWObjectId] [int] NOT NULL,
[SSRSObjectId] [int] NOT NULL,
CONSTRAINT [PK_DWtoSSRSObjects] PRIMARY KEY CLUSTERED
( [DWObjectId] ASC, [SSRSObjectId] ASC )
)
GO
CREATE TABLE [dbo].[SSASToSSRSObjects](
[SSASObjectId] [int] NOT NULL,
[SSRSObjectId] [int] NOT NULL,
CONSTRAINT [PK_SSASToSSRSObjects] PRIMARY KEY CLUSTERED
( [SSASObjectId] ASC, [SSRSObjectId] ASC )
)
GO
-- Create the FKs to the ObjectTypes domain table --
ALTER TABLE [dbo].[DWObjects]
ADD CONSTRAINT [FK_DWObjects_ObjectTypes] FOREIGN KEY([ObjectTypeId])
REFERENCES [dbo].[ObjectTypes] ([ObjectTypeId])
GO
ALTER TABLE [dbo].[SSISObjects]
ADD CONSTRAINT [FK_SSISObjects_ObjectTypes] FOREIGN KEY([ObjectTypeId])
REFERENCES [dbo].[ObjectTypes] ([ObjectTypeId])
GO
ALTER TABLE [dbo].[SSASObjects]
ADD CONSTRAINT [FK_SSASObjects_ObjectTypes] FOREIGN KEY([ObjectTypeId])
REFERENCES [dbo].[ObjectTypes] ([ObjectTypeId])
GO
ALTER TABLE [dbo].[ExcelReportObjects]
ADD CONSTRAINT [FK_ExcelReportObjects_ObjectTypes] FOREIGN KEY([ObjectTypeId])
REFERENCES [dbo].[ObjectTypes] ([ObjectTypeId])
GO
