[dbo].[DTA_reports_querydatabase]

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_querydatabase_index: SessionID\QueryID$ $Foreign Keys DTA_reports_querydatabase_fk: [dbo].[DTA_reports_query].SessionID\QueryID$	QueryID	int	4
$Cluster Key DTA_reports_querydatabase_index: SessionID\QueryID$ $Foreign Keys DTA_reports_querydatabase_fk: [dbo].[DTA_reports_query].SessionID\QueryID$	SessionID	int	4
	DatabaseID	int	4

Name

Data Type

Max Length (Bytes)

Allow Nulls

$Cluster Key DTA_reports_querydatabase_index: SessionID\QueryID$ $Foreign Keys DTA_reports_querydatabase_fk: [dbo].[DTA_reports_query].SessionID\QueryID$

QueryID

int

$Cluster Key DTA_reports_querydatabase_index: SessionID\QueryID$ $Foreign Keys DTA_reports_querydatabase_fk: [dbo].[DTA_reports_query].SessionID\QueryID$

SessionID

int

DatabaseID

int

	Name	Columns
$Cluster Key DTA_reports_querydatabase_index: SessionID\QueryID$	DTA_reports_querydatabase_index	SessionID, QueryID
	DTA_reports_querydatabase_index2	DatabaseID

Name

Columns

$Cluster Key DTA_reports_querydatabase_index: SessionID\QueryID$

DTA_reports_querydatabase_index

SessionID, QueryID

DTA_reports_querydatabase_index2

DatabaseID

Name	Delete	Columns
DTA_reports_querydatabase_fk	Cascade	SessionID->[dbo].[DTA_reports_query].[SessionID] QueryID->[dbo].[DTA_reports_query].[QueryID]
FK__DTA_repor__Datab__4AD81681		DatabaseID->[dbo].[DTA_reports_database].[DatabaseID]

Name

Delete

Columns

DTA_reports_querydatabase_fk

Cascade

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

FK__DTA_repor__Datab__4AD81681

DatabaseID->[dbo].[DTA_reports_database].[DatabaseID]

SQL Script

CREATE TABLE [dbo].[DTA_reports_querydatabase]
(
[QueryID] [int] NOT NULL,
[SessionID] [int] NOT NULL,
[DatabaseID] [int] NOT NULL
) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [DTA_reports_querydatabase_index2] ON [dbo].[DTA_reports_querydatabase] ([DatabaseID]) ON [PRIMARY]
GO
CREATE CLUSTERED INDEX [DTA_reports_querydatabase_index] ON [dbo].[DTA_reports_querydatabase] ([SessionID], [QueryID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[DTA_reports_querydatabase] ADD CONSTRAINT [DTA_reports_querydatabase_fk] FOREIGN KEY ([SessionID], [QueryID]) REFERENCES [dbo].[DTA_reports_query] ([SessionID], [QueryID]) ON DELETE CASCADE
GO
ALTER TABLE [dbo].[DTA_reports_querydatabase] ADD CONSTRAINT [FK__DTA_repor__Datab__4AD81681] FOREIGN KEY ([DatabaseID]) REFERENCES [dbo].[DTA_reports_database] ([DatabaseID])
GO