Database Reference
In-Depth Information
CONSTRAINT [PK_DWObjects] PRIMARY KEY CLUSTERED
( [DWObjectId] ASC )
)
GO
CREATE TABLE [dbo].[SSISObjects](
[SSISObjectId] [int] NOT NULL,
[SSISObjectName] [nvarchar](100) NULL,
[ObjectTypeId] [int] NULL,
[CurrentlyUsed] [bit] NULL,
CONSTRAINT [PK_SSISObjects] PRIMARY KEY CLUSTERED
( [SSISObjectId] ASC )
)
GO
CREATE TABLE [dbo].[SSASObjects](
[SSASObjectId] [int] NOT NULL,
[SSASObjectName] [nvarchar](100) NULL,
[ObjectTypeId] [int] NULL,
[CurrentlyUsed] [bit] NULL,
CONSTRAINT [PK_SSASObjects] PRIMARY KEY CLUSTERED
( [SSASObjectId] ASC )
)
GO
CREATE TABLE [dbo].[ExcelReportObjects](
[ExcelReportObjectId] [int] NOT NULL,
[ExcelReportObjectName] [nvarchar](100) NULL,
[ObjectTypeId] [int] NULL,
[CurrentlyUsed] [bit] NULL,
CONSTRAINT [PK_ExcelReportObjects] PRIMARY KEY CLUSTERED
( [ExcelReportObjectId] ASC )
)
GO
CREATE TABLE [dbo].[SSRSObjects](
[SSRSObjectId] [int] NOT NULL,
[SSRSObjectName] [nvarchar](100) NULL,
[ObjectTypeId] [int] NULL,
[CurrentlyUsed] [bit] NULL,
CONSTRAINT [PK_SSRSObjects] PRIMARY KEY CLUSTERED
( [SSRSObjectId] ASC )
)
GO
-- and their relationship tables --
CREATE TABLE [dbo].[DWToSSISObjects](
[DWObjectId] [int] NOT NULL,
[SSIDObjectID] [int] NOT NULL,
CONSTRAINT [PK_DWToSSISObjects] PRIMARY KEY CLUSTERED
( [DWObjectId] ASC, [SSIDObjectID] ASC )
)
GO
