[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_querytable_index: SessionID\QueryID$ $Foreign Keys DTA_reports_querytable_fk: [dbo].[DTA_reports_query].SessionID\QueryID$	QueryID	int	4
$Cluster Key DTA_reports_querytable_index: SessionID\QueryID$ $Foreign Keys DTA_reports_querytable_fk: [dbo].[DTA_reports_query].SessionID\QueryID$	SessionID	int	4
	TableID	int	4

Name

Data Type

Max Length (Bytes)

Allow Nulls

$Cluster Key DTA_reports_querytable_index: SessionID\QueryID$ $Foreign Keys DTA_reports_querytable_fk: [dbo].[DTA_reports_query].SessionID\QueryID$

QueryID

int

$Cluster Key DTA_reports_querytable_index: SessionID\QueryID$ $Foreign Keys DTA_reports_querytable_fk: [dbo].[DTA_reports_query].SessionID\QueryID$

SessionID

int

TableID

int

	Name	Columns
$Cluster Key DTA_reports_querytable_index: SessionID\QueryID$	DTA_reports_querytable_index	SessionID, QueryID
	DTA_reports_querytable_index2	TableID

Name

Columns

$Cluster Key DTA_reports_querytable_index: SessionID\QueryID$

DTA_reports_querytable_index

SessionID, QueryID

DTA_reports_querytable_index2

TableID

Name	Delete	Columns
DTA_reports_querytable_fk	Cascade	SessionID->[dbo].[DTA_reports_query].[SessionID] QueryID->[dbo].[DTA_reports_query].[QueryID]
FK__DTA_repor__Table__47FBA9D6		TableID->[dbo].[DTA_reports_table].[TableID]

Name

Delete

Columns

DTA_reports_querytable_fk

Cascade

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

FK__DTA_repor__Table__47FBA9D6

TableID->[dbo].[DTA_reports_table].[TableID]

SQL Script

CREATE TABLE [dbo].[DTA_reports_querytable]
(
[QueryID] [int] NOT NULL,
[SessionID] [int] NOT NULL,
[TableID] [int] NOT NULL
) ON [PRIMARY]
GO
CREATE CLUSTERED INDEX [DTA_reports_querytable_index] ON [dbo].[DTA_reports_querytable] ([SessionID], [QueryID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [DTA_reports_querytable_index2] ON [dbo].[DTA_reports_querytable] ([TableID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[DTA_reports_querytable] ADD CONSTRAINT [DTA_reports_querytable_fk] FOREIGN KEY ([SessionID], [QueryID]) REFERENCES [dbo].[DTA_reports_query] ([SessionID], [QueryID]) ON DELETE CASCADE
GO
ALTER TABLE [dbo].[DTA_reports_querytable] ADD CONSTRAINT [FK__DTA_repor__Table__47FBA9D6] FOREIGN KEY ([TableID]) REFERENCES [dbo].[DTA_reports_table] ([TableID])
GO