[dbo].[DTA_tuninglog]

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

Property

Value

Collation

SQL_Latin1_General_CP1_CI_AS

Row Count

Created

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

Last Modified

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

	Name	Data Type	Max Length (Bytes)
$Cluster Key DTA_tuninglog_index: SessionID\RowID$	SessionID	int	4
$Cluster Key DTA_tuninglog_index: SessionID\RowID$	RowID	int	4
	CategoryID	nvarchar(4)	8
	Event	ntext	max
	Statement	ntext	max
	Frequency	int	4
	Reason	ntext	max

Name

Data Type

Max Length (Bytes)

Allow Nulls

$Cluster Key DTA_tuninglog_index: SessionID\RowID$

SessionID

int

$Cluster Key DTA_tuninglog_index: SessionID\RowID$

RowID

int

CategoryID

nvarchar(4)

Event

ntext

max

Statement

ntext

max

Frequency

int

Reason

ntext

max

	Name	Columns
$Cluster Key DTA_tuninglog_index: SessionID\RowID$	DTA_tuninglog_index	SessionID, RowID

Name

Columns

$Cluster Key DTA_tuninglog_index: SessionID\RowID$

DTA_tuninglog_index

SessionID, RowID

Name	Delete	Columns
FK__DTA_tunin__Sessi__33F4B129	Cascade	SessionID->[dbo].[DTA_input].[SessionID]

Name

Delete

Columns

FK__DTA_tunin__Sessi__33F4B129

Cascade

SessionID->[dbo].[DTA_input].[SessionID]

SQL Script

CREATE TABLE [dbo].[DTA_tuninglog]
(
[SessionID] [int] NOT NULL,
[RowID] [int] NOT NULL,
[CategoryID] [nvarchar] (4) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Event] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Statement] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Frequency] [int] NOT NULL,
[Reason] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
CREATE CLUSTERED INDEX [DTA_tuninglog_index] ON [dbo].[DTA_tuninglog] ([SessionID], [RowID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[DTA_tuninglog] ADD CONSTRAINT [FK__DTA_tunin__Sessi__33F4B129] FOREIGN KEY ([SessionID]) REFERENCES [dbo].[DTA_input] ([SessionID]) ON DELETE CASCADE
GO