SQL AUDIT TASK SUMMARY Table Script

To create a table for AUDIT TASK SUMMARY. Script with drop and create.


USE [Work]  --DB Name
GO
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[AuditTaskSummary]') AND type in (N'U'))
DROP TABLE [dbo].[AuditTaskSummary]


USE [Work]  --DB Name
GO
CREATE TABLE [dbo].[AuditTaskSummary](
[SummaryDate] [datetime] NULL,
[maxAuditTaskId] [bigint] NULL,
[PackageName] [varchar](100) NOT NULL,
[TableName] [varchar](255) NULL
) ON [PRIMARY]