Tables [dbo].[DTA_reports_database]
Properties
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count0
Created1:20:07 PM Friday, May 11, 2007
Last Modified1:20:07 PM Friday, May 11, 2007
Columns
NameData TypeMax Length (Bytes)Allow NullsIdentity
Cluster Primary Key PK__DTA_reports_data__35DCF99B: DatabaseIDDatabaseIDint4
No
1 - 1
Foreign Keys FK__DTA_repor__Sessi__36D11DD4: [dbo].[DTA_input].SessionIDIndexes DTA_reports_database_index: SessionIDSessionIDint4
No
DatabaseName[sys].[sysname]256
No
IsDatabaseSelectedToTuneint4
Yes
Indexes Indexes
NameColumnsUnique
Cluster Primary Key PK__DTA_reports_data__35DCF99B: DatabaseIDPK__DTA_reports_data__35DCF99BDatabaseID
Yes
DTA_reports_database_indexSessionID
Foreign Keys Foreign Keys
NameDeleteColumns
FK__DTA_repor__Sessi__36D11DD4CascadeSessionID->[dbo].[DTA_input].[SessionID]
SQL Script
CREATE TABLE [dbo].[DTA_reports_database]
(
[DatabaseID] [int] NOT NULL IDENTITY(1, 1),
[SessionID] [int] NOT NULL,
[DatabaseName] [sys].[sysname] NOT NULL,
[IsDatabaseSelectedToTune] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[DTA_reports_database] ADD CONSTRAINT [PK__DTA_reports_data__35DCF99B] PRIMARY KEY CLUSTERED ([DatabaseID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [DTA_reports_database_index] ON [dbo].[DTA_reports_database] ([SessionID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[DTA_reports_database] ADD CONSTRAINT [FK__DTA_repor__Sessi__36D11DD4] FOREIGN KEY ([SessionID]) REFERENCES [dbo].[DTA_input] ([SessionID]) ON DELETE CASCADE
GO
Uses
Used By