CREATE TABLE [dbo].[DTA_input]
(
[SessionName] [sys].[sysname] NOT NULL,
[SessionID] [int] NOT NULL IDENTITY(1, 1),
[TuningOptions] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[CreationTime] [datetime] NOT NULL CONSTRAINT [DF__DTA_input__Creat__22CA2527] DEFAULT (getdate()),
[ScheduledStartTime] [datetime] NOT NULL CONSTRAINT [DF__DTA_input__Sched__23BE4960] DEFAULT (getdate()),
[ScheduledJobName] [sys].[sysname] NOT NULL CONSTRAINT [DF__DTA_input__Sched__24B26D99] DEFAULT (''),
[InteractiveStatus] [tinyint] NOT NULL CONSTRAINT [DF__DTA_input__Inter__25A691D2] DEFAULT ((0)),
[LogTableName] [nvarchar] (1280) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF__DTA_input__LogTa__269AB60B] DEFAULT (''),
[GlobalSessionID] [uniqueidentifier] NULL CONSTRAINT [DF__DTA_input__Globa__278EDA44] DEFAULT (newid())
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE [dbo].[DTA_input] ADD CONSTRAINT [PK__DTA_input__21D600EE] PRIMARY KEY CLUSTERED ([SessionID]) ON [PRIMARY]
GO
[dbo].[DTA_input]
