[dbo].[DTA_reports_querycolumn]

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_querycolumn_index: SessionID\QueryID$ $Foreign Keys DTA_reports_querycolumn_fk: [dbo].[DTA_reports_query].SessionID\QueryID$	QueryID	int	4
$Cluster Key DTA_reports_querycolumn_index: SessionID\QueryID$ $Foreign Keys DTA_reports_querycolumn_fk: [dbo].[DTA_reports_query].SessionID\QueryID$	SessionID	int	4
	ColumnID	int	4

Name

Data Type

Max Length (Bytes)

Allow Nulls

$Cluster Key DTA_reports_querycolumn_index: SessionID\QueryID$ $Foreign Keys DTA_reports_querycolumn_fk: [dbo].[DTA_reports_query].SessionID\QueryID$

QueryID

int

$Cluster Key DTA_reports_querycolumn_index: SessionID\QueryID$ $Foreign Keys DTA_reports_querycolumn_fk: [dbo].[DTA_reports_query].SessionID\QueryID$

SessionID

int

ColumnID

int

	Name	Columns
$Cluster Key DTA_reports_querycolumn_index: SessionID\QueryID$	DTA_reports_querycolumn_index	SessionID, QueryID
	DTA_reports_querycolumn_index2	ColumnID

Name

Columns

$Cluster Key DTA_reports_querycolumn_index: SessionID\QueryID$

DTA_reports_querycolumn_index

SessionID, QueryID

DTA_reports_querycolumn_index2

ColumnID

Name	Delete	Columns
DTA_reports_querycolumn_fk	Cascade	SessionID->[dbo].[DTA_reports_query].[SessionID] QueryID->[dbo].[DTA_reports_query].[QueryID]
FK__DTA_repor__Colum__5FD33367		ColumnID->[dbo].[DTA_reports_column].[ColumnID]

Name

Delete

Columns

DTA_reports_querycolumn_fk

Cascade

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

FK__DTA_repor__Colum__5FD33367

ColumnID->[dbo].[DTA_reports_column].[ColumnID]

SQL Script

CREATE TABLE [dbo].[DTA_reports_querycolumn]
(
[QueryID] [int] NOT NULL,
[SessionID] [int] NOT NULL,
[ColumnID] [int] NOT NULL
) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [DTA_reports_querycolumn_index2] ON [dbo].[DTA_reports_querycolumn] ([ColumnID]) ON [PRIMARY]
GO
CREATE CLUSTERED INDEX [DTA_reports_querycolumn_index] ON [dbo].[DTA_reports_querycolumn] ([SessionID], [QueryID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[DTA_reports_querycolumn] ADD CONSTRAINT [DTA_reports_querycolumn_fk] FOREIGN KEY ([SessionID], [QueryID]) REFERENCES [dbo].[DTA_reports_query] ([SessionID], [QueryID]) ON DELETE CASCADE
GO
ALTER TABLE [dbo].[DTA_reports_querycolumn] ADD CONSTRAINT [FK__DTA_repor__Colum__5FD33367] FOREIGN KEY ([ColumnID]) REFERENCES [dbo].[DTA_reports_column] ([ColumnID])
GO