[dbo].[DTA_reports_indexcolumn]
CREATE TABLE [dbo].[DTA_reports_indexcolumn]
(
[IndexID] [int] NOT NULL,
[ColumnID] [int] NOT NULL,
[ColumnOrder] [int] NULL,
[PartitionColumnOrder] [int] NOT NULL CONSTRAINT [DF__DTA_repor__Parti__5C02A283] DEFAULT ((0)),
[IsKeyColumn] [bit] NOT NULL CONSTRAINT [DF__DTA_repor__IsKey__5CF6C6BC] DEFAULT ((1)),
[IsDescendingColumn] [bit] NOT NULL CONSTRAINT [DF__DTA_repor__IsDes__5DEAEAF5] DEFAULT ((1))
) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [DTA_reports_indexcolumn_index2] ON [dbo].[DTA_reports_indexcolumn] ([ColumnID]) ON [PRIMARY]
GO
CREATE CLUSTERED INDEX [DTA_reports_indexcolumn_index] ON [dbo].[DTA_reports_indexcolumn] ([IndexID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[DTA_reports_indexcolumn] ADD CONSTRAINT [FK__DTA_repor__Index__5B0E7E4A] FOREIGN KEY ([IndexID]) REFERENCES [dbo].[DTA_reports_index] ([IndexID]) ON DELETE CASCADE
GO
![Foreign Keys FK__DTA_repor__Index__5B0E7E4A: [dbo].[DTA_reports_index].IndexID](../../Images/fk.gif)
