CREATE TABLE [dbo].[DTA_reports_index]
(
[IndexID] [int] NOT NULL IDENTITY(1, 1),
[TableID] [int] NOT NULL,
[IndexName] [sys].[sysname] NOT NULL,
[IsClustered] [bit] NOT NULL CONSTRAINT [DF__DTA_repor__IsClu__4F9CCB9E] DEFAULT ((0)),
[IsUnique] [bit] NOT NULL CONSTRAINT [DF__DTA_repor__IsUni__5090EFD7] DEFAULT ((0)),
[IsHeap] [bit] NOT NULL CONSTRAINT [DF__DTA_repor__IsHea__51851410] DEFAULT ((1)),
[IsExisting] [bit] NOT NULL CONSTRAINT [DF__DTA_repor__IsExi__52793849] DEFAULT ((1)),
[Storage] [float] NOT NULL,
[NumRows] [int] NOT NULL,
[IsRecommended] [bit] NOT NULL CONSTRAINT [DF__DTA_repor__IsRec__536D5C82] DEFAULT ((0)),
[RecommendedStorage] [float] NOT NULL,
[PartitionSchemeID] [int] NULL,
[SessionUniquefier] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[DTA_reports_index] ADD CONSTRAINT [PK__DTA_reports_inde__4DB4832C] PRIMARY KEY CLUSTERED ([IndexID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [DTA_reports_indexindex2] ON [dbo].[DTA_reports_index] ([PartitionSchemeID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [DTA_reports_indexindex] ON [dbo].[DTA_reports_index] ([TableID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[DTA_reports_index] ADD CONSTRAINT [FK__DTA_repor__Table__4EA8A765] FOREIGN KEY ([TableID]) REFERENCES [dbo].[DTA_reports_table] ([TableID]) ON DELETE CASCADE
GO