Tables [dbo].[DTA_output]
Properties
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count0
Created1:20:06 PM Friday, May 11, 2007
Last Modified1:20:06 PM Friday, May 11, 2007
Columns
NameData TypeMax Length (Bytes)Allow NullsDefault
Cluster Primary Key PK__DTA_output__2F2FFC0C: SessionIDForeign Keys FK__DTA_outpu__Sessi__30242045: [dbo].[DTA_input].SessionIDSessionIDint4
No
TuningResultsntextmax
No
StopTimedatetime8
No
(getdate())
FinishStatustinyint1
No
((0))
Indexes Indexes
NameColumnsUnique
Cluster Primary Key PK__DTA_output__2F2FFC0C: SessionIDPK__DTA_output__2F2FFC0CSessionID
Yes
Foreign Keys Foreign Keys
NameDeleteColumns
FK__DTA_outpu__Sessi__30242045CascadeSessionID->[dbo].[DTA_input].[SessionID]
SQL Script
CREATE TABLE [dbo].[DTA_output]
(
[SessionID] [int] NOT NULL,
[TuningResults] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[StopTime] [datetime] NOT NULL CONSTRAINT [DF__DTA_outpu__StopT__3118447E] DEFAULT (getdate()),
[FinishStatus] [tinyint] NOT NULL CONSTRAINT [DF__DTA_outpu__Finis__320C68B7] DEFAULT ((0))
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE [dbo].[DTA_output] ADD CONSTRAINT [PK__DTA_output__2F2FFC0C] PRIMARY KEY CLUSTERED ([SessionID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[DTA_output] ADD CONSTRAINT [FK__DTA_outpu__Sessi__30242045] FOREIGN KEY ([SessionID]) REFERENCES [dbo].[DTA_input] ([SessionID]) ON DELETE CASCADE
GO
Uses
Used By