14 lines
654 B
Transact-SQL
14 lines
654 B
Transact-SQL
CREATE TABLE [dbo].[CRT_Tasks] (
|
|
[CRTT_ID] INT IDENTITY (1, 1) NOT FOR REPLICATION NOT NULL,
|
|
[CRTT_Name] VARCHAR (100) NOT NULL,
|
|
[CRTT_TableName] [sysname] NOT NULL,
|
|
[CRTT_Source_TableName] [sysname] NOT NULL,
|
|
[CRTT_UnitDefinition] VARCHAR (15) NOT NULL,
|
|
[CRTT_LastRun] DATETIME NULL,
|
|
[CRTT_IsActive] BIT CONSTRAINT [DF_CRT_Tasks_CRTT_IsActive] DEFAULT ((1)) NOT NULL,
|
|
[CRTT_LastRowCount] INT NULL,
|
|
[CRTT_LastModifiedDate] DATETIME NULL,
|
|
CONSTRAINT [PK_CRT_Tasks] PRIMARY KEY CLUSTERED ([CRTT_ID] ASC)
|
|
);
|
|
|