[dbo].[DTA_reports

Property	Value
Row Count	0
Created	1:20:07 PM Friday, May 11, 2007
Last Modified	1:20:07 PM Friday, May 11, 2007

Property

Value

Row Count

Created

1:20:07 PM Friday, May 11, 2007

Last Modified

1:20:07 PM Friday, May 11, 2007

	Name	Data Type	Max Length (Bytes)
$Cluster Key DTA_reports_queryindex_index: SessionID\QueryID$ $Foreign Keys DTA_reports_queryindex_fk: [dbo].[DTA_reports_query].SessionID\QueryID$	QueryID	int	4
$Cluster Key DTA_reports_queryindex_index: SessionID\QueryID$ $Foreign Keys DTA_reports_queryindex_fk: [dbo].[DTA_reports_query].SessionID\QueryID$	SessionID	int	4
	IndexID	int	4
	IsRecommendedConfiguration	bit	1

Name

Data Type

Max Length (Bytes)

Allow Nulls

$Cluster Key DTA_reports_queryindex_index: SessionID\QueryID$ $Foreign Keys DTA_reports_queryindex_fk: [dbo].[DTA_reports_query].SessionID\QueryID$

QueryID

int

$Cluster Key DTA_reports_queryindex_index: SessionID\QueryID$ $Foreign Keys DTA_reports_queryindex_fk: [dbo].[DTA_reports_query].SessionID\QueryID$

SessionID

int

IndexID

int

IsRecommendedConfiguration

bit

	Name	Columns
$Cluster Key DTA_reports_queryindex_index: SessionID\QueryID$	DTA_reports_queryindex_index	SessionID, QueryID
	DTA_reports_queryindex_index2	IndexID

Name

Columns

$Cluster Key DTA_reports_queryindex_index: SessionID\QueryID$

DTA_reports_queryindex_index

SessionID, QueryID

DTA_reports_queryindex_index2

IndexID

Name	Delete	Columns
DTA_reports_queryindex_fk	Cascade	SessionID->[dbo].[DTA_reports_query].[SessionID] QueryID->[dbo].[DTA_reports_query].[QueryID]
FK__DTA_repor__Index__5555A4F4		IndexID->[dbo].[DTA_reports_index].[IndexID]

Name

Delete

Columns

DTA_reports_queryindex_fk

Cascade

SessionID->[dbo].[DTA_reports_query].[SessionID]
QueryID->[dbo].[DTA_reports_query].[QueryID]

FK__DTA_repor__Index__5555A4F4

IndexID->[dbo].[DTA_reports_index].[IndexID]

SQL Script

CREATE TABLE [dbo].[DTA_reports_queryindex]
(
[QueryID] [int] NOT NULL,
[SessionID] [int] NOT NULL,
[IndexID] [int] NOT NULL,
[IsRecommendedConfiguration] [bit] NOT NULL
) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [DTA_reports_queryindex_index2] ON [dbo].[DTA_reports_queryindex] ([IndexID]) ON [PRIMARY]
GO
CREATE CLUSTERED INDEX [DTA_reports_queryindex_index] ON [dbo].[DTA_reports_queryindex] ([SessionID], [QueryID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[DTA_reports_queryindex] ADD CONSTRAINT [DTA_reports_queryindex_fk] FOREIGN KEY ([SessionID], [QueryID]) REFERENCES [dbo].[DTA_reports_query] ([SessionID], [QueryID]) ON DELETE CASCADE
GO
ALTER TABLE [dbo].[DTA_reports_queryindex] ADD CONSTRAINT [FK__DTA_repor__Index__5555A4F4] FOREIGN KEY ([IndexID]) REFERENCES [dbo].[DTA_reports_index] ([IndexID])
GO