
[dbo].[DTA_reports_database]
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