CRM批注

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CRM_SchedulePostil]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[CRM_SchedulePostil]
GO

if not exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CRM_SchedulePostil]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
 BEGIN
CREATE TABLE [dbo].[CRM_SchedulePostil] (
 [ID] [int] IDENTITY (1, 1) NOT NULL ,
 [CoScheduleTypeID] [varchar] (30) NOT NULL ,
 [Description] [varchar] (3000) NOT NULL ,
 [CreatorTypeID] [varchar] (30) NOT NULL ,
 [CreateDate] [datetime] NOT NULL
) ON [PRIMARY]
END

GO