
[dbo].[DTA_reports_table]
CREATE TABLE [dbo].[DTA_reports_table]
(
[TableID] [int] NOT NULL IDENTITY(1, 1),
[DatabaseID] [int] NOT NULL,
[SchemaName] [sys].[sysname] NOT NULL,
[TableName] [sys].[sysname] NOT NULL,
[IsView] [bit] NOT NULL CONSTRAINT [DF__DTA_repor__IsVie__405A880E] DEFAULT ((0))
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[DTA_reports_table] ADD CONSTRAINT [PK__DTA_reports_tabl__3E723F9C] PRIMARY KEY CLUSTERED ([TableID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [DTA_reports_table_index] ON [dbo].[DTA_reports_table] ([DatabaseID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[DTA_reports_table] ADD CONSTRAINT [FK__DTA_repor__Datab__3F6663D5] FOREIGN KEY ([DatabaseID]) REFERENCES [dbo].[DTA_reports_database] ([DatabaseID]) ON DELETE CASCADE
GO