if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TABLE1]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[TABLE1] GOCREATE TABLE [dbo].[TABLE1] ( [aa] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL , [bb] [datetime] NOT NULL ) ON [PRIMARY] GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TABLE1]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[TABLE1] GOCREATE TABLE [dbo].[NewTable] ( [aa] [char] (10) not null default 0, [bb] [datetime] not null default getdate() ) ON [PRIMARY] GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TABLE1]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[TABLE1] GOCREATE TABLE [dbo].[NewTable] ( [aa] [char] (10) not null default 0, [bb] [datetime] not null default getdate() ) ON [PRIMARY] GO
drop table [dbo].[TABLE1]
GOCREATE TABLE [dbo].[TABLE1] (
[aa] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[bb] [datetime] NOT NULL
) ON [PRIMARY]
GO
drop table [dbo].[TABLE1]
GOCREATE TABLE [dbo].[NewTable] (
[aa] [char] (10) not null default 0,
[bb] [datetime] not null default getdate()
) ON [PRIMARY]
GO
drop table [dbo].[TABLE1]
GOCREATE TABLE [dbo].[NewTable] (
[aa] [char] (10) not null default 0,
[bb] [datetime] not null default getdate()
) ON [PRIMARY]
GO