请帮忙看看 错误是什么

tq04m2w

use master
go

if exists (select * from dbo.sysdatabases where name = 'Material')
drop database Material
GO

create database Material
go
use Material
go


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

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

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

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

CREATE TABLE [dbo].[material] (
        [wzid] [char] (8) COLLATE Chinese_PRC_CI_AS NOT NULL ,
        [wzname] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
        [wzspec] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
        [wzkind] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
        [wzunit] [char] (10) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[msave] (
        [rkno] [char] (14) COLLATE Chinese_PRC_CI_AS NOT NULL ,
        [rkid] [char] (8) COLLATE Chinese_PRC_CI_AS NOT NULL ,
        [rkname] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
        [rkspec] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
        [rkkind] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
        [rkunit] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
        [rkaccount] [numeric](5, 0) NOT NULL ,
        [rkprice] [numeric](8, 2) NOT NULL ,
        [rkvalue] [numeric](10, 2) NOT NULL ,
        [rkdate] [datetime] NOT NULL ,
        [rkdeal_person] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
        [rksave_person] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
        [rkbase] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
        [rkmemo] [text] COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[msurplus] (
        [yeid] [char] (8) COLLATE Chinese_PRC_CI_AS NOT NULL ,
        [yename] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
        [yespec] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
        [yekind] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
        [yeunit] [char] (2) COLLATE Chinese_PRC_CI_AS NULL ,
        [yeaccount] [numeric](5, 0) NOT NULL ,
        [yevalue] [numeric](10, 2) NOT NULL ,
        [yebase] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
        [yememo] [text] COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[muse] (
        [lyno] [char] (14) COLLATE Chinese_PRC_CI_AS NOT NULL ,
        [lyid] [char] (8) COLLATE Chinese_PRC_CI_AS NOT NULL ,
        [lyname] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
        [lyspec] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
        [lykind] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
        [lyunit] [char] (2) COLLATE Chinese_PRC_CI_AS NULL ,
        [lyaccount] [numeric](5, 0) NOT NULL ,
        [lyprice] [numeric](8, 2) NULL ,
        [lyvalue] [numeric](10, 2) NULL ,
        [lydate] [datetime] NOT NULL ,
        [lyuse_person] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
        [lydeal_person] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
        [lybase] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
        [lymemo] [text] COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

firegao

你执行一下不就知道了？