请帮忙解读一下这个mssql脚本每句的含义以及整个脚本的用法解决方法

请帮忙解读一下这个mssql脚本每句的含义以及整个脚本的用法
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[AutoDuty]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[AutoDuty]
GO

CREATE TABLE [dbo].[AutoDuty] (
 [ID] [int] IDENTITY (1, 1) NOT NULL ,
 [AutoType] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
 [AutoContent] [nvarchar] (60) COLLATE Chinese_PRC_CI_AS NOT NULL ,
 [RTime] [datetime] NOT NULL ,
 [OTime] [datetime] NULL ,
 [IsOk] [int] NOT NULL ,
 [Notes] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[AutoDuty] WITH NOCHECK ADD
 CONSTRAINT [PK_AutoNotice] PRIMARY KEY CLUSTERED
 (
  [ID]
 ) ON [PRIMARY]
GO

ALTER TABLE [dbo].[AutoDuty] ADD
 CONSTRAINT [DF_AutoDuty_AutoType] DEFAULT ('喊话') FOR [AutoType],
 CONSTRAINT [DF_AutoNotice_RTime] DEFAULT (getdate()) FOR [RTime],
 CONSTRAINT [DF_AutoNotice_IsOk] DEFAULT (0) FOR [IsOk]
GO

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

CREATE TABLE [dbo].[AutoSystem] (
 [AutoOpen] [int] NOT NULL
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[AutoSystem] ADD
 CONSTRAINT [DF_AutoSystem_AutoOpen] DEFAULT (0) FOR [AutoOpen]
GO

insert into AutoSystem ([AutoOpen]) values ('1')


[解决办法]
判断表是否存在
如果存在删除之
建立表
添加主键约束
添加默认值约束
下面同上
[解决办法]

SQL code

--功过系统表来判断该名称的表是否存在if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[AutoDuty]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)--存在删除该表drop table [dbo].[AutoDuty]GO--创建表语法CREATE TABLE [dbo].[AutoDuty] ( [ID] [int] IDENTITY (1, 1) NOT NULL ,  --自增列的创建 [AutoType] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,  --指定排序规则，详细可以查资料 [AutoContent] [nvarchar] (60) COLLATE Chinese_PRC_CI_AS NOT NULL , [RTime] [datetime] NOT NULL ,  --NOT NULL约束 [OTime] [datetime] NULL , [IsOk] [int] NOT NULL , [Notes] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL) ON [PRIMARY]GO--添加约束  （主键约束）ALTER TABLE [dbo].[AutoDuty] WITH NOCHECK ADD CONSTRAINT [PK_AutoNotice] PRIMARY KEY CLUSTERED (  [ID] ) ON [PRIMARY]GO--添加约束  DEFAULT 的默认值约束ALTER TABLE [dbo].[AutoDuty] ADD CONSTRAINT [DF_AutoDuty_AutoType] DEFAULT ('喊话') FOR [AutoType],   CONSTRAINT [DF_AutoNotice_RTime] DEFAULT (getdate()) FOR [RTime], CONSTRAINT [DF_AutoNotice_IsOk] DEFAULT (0) FOR [IsOk]GO