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

CREATE TABLE [dbo].[TBL_CHARACTER_INFO] (
    [ID] [int] IDENTITY (1, 1) NOT NULL ,
    [ACCOUNT] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
    [NAME] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
    [CLASS] [tinyint] NOT NULL ,
    [SEX] [tinyint] NOT NULL ,
    [VLEVEL] [smallint] NOT NULL ,
    [MAPNAME] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
    [POSX] [smallint] NOT NULL ,
    [POSY] [smallint] NOT NULL ,
    [HAIR] [tinyint] NOT NULL ,
    [SERVER] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
    [ODATE] [datetime] NOT NULL ,
    [DELFLAG] [tinyint] NOT NULL ,
    [DELDATE] [datetime] NOT NULL ,
    [CREATEDATE] [datetime] NOT NULL ,
    [CUREXP] [int] NOT NULL ,
    [HP] [smallint] NOT NULL ,
    [MP] [smallint] NOT NULL ,
    [MAXHP] [smallint] NOT NULL ,
    [MAXMP] [smallint] NOT NULL ,
    [MINDC] [tinyint] NOT NULL ,
    [MAXDC] [tinyint] NOT NULL ,
    [MINMC] [tinyint] NOT NULL ,
    [MAXMC] [tinyint] NOT NULL ,
    [MINSC] [tinyint] NOT NULL ,
    [MAXSC] [tinyint] NOT NULL ,
    [MINAC] [tinyint] NOT NULL ,
    [MAXAC] [tinyint] NOT NULL ,
    [MINMAC] [tinyint] NOT NULL ,
    [MAXMAC] [tinyint] NOT NULL ,
    [WEIGHT] [smallint] NOT NULL ,
    [HANDWEIGHT] [tinyint] NOT NULL ,
    [BODYWEIGHT] [tinyint] NOT NULL ,
    [GOLD] [int] NOT NULL ,
    [MAPID] [int] NOT NULL ,
    [YUANBAO] [int] NOT NULL ,
    [FLAG1] [int] NOT NULL ,
    [FLAG2] [int] NOT NULL ,
    [FLAG3] [int] NOT NULL ,
    [FLAG4] [int] NOT NULL ,
        [GUILDNAME] [varchar] (50) NOT NULL ,
        [FORGEPOINT] [int] NOT NULL ,
        [PROP1] [int] NOT NULL ,
        [PROP2] [int] NOT NULL ,
        [PROP3] [int] NOT NULL ,
        [PROP4] [int] NOT NULL ,
        [PROP5] [int] NOT NULL ,
        [PROP6] [int] NOT NULL ,
        [PROP7] [int] NOT NULL ,
        [PROP8] [int] NOT NULL
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[TBL_CHARACTER_INFO] WITH NOCHECK ADD
    CONSTRAINT [DF_TBL_CHARACTER_INFO_ACCOUNT] DEFAULT ('') FOR [ACCOUNT],
    CONSTRAINT [DF_TBL_CHARACTER_INFO_NAME] DEFAULT ('') FOR [NAME],
    CONSTRAINT [DF_TBL_CHARACTER_INFO_CLASS] DEFAULT (0) FOR [CLASS],
    CONSTRAINT [DF_TBL_CHARACTER_INFO_SEX] DEFAULT (0) FOR [SEX],
    CONSTRAINT [DF_TBL_CHARACTER_INFO_VLEVEL] DEFAULT (0) FOR [VLEVEL],
    CONSTRAINT [DF_TBL_CHARACTER_INFO_MAPNAME] DEFAULT ('0') FOR [MAPNAME],
    CONSTRAINT [DF_TBL_CHARACTER_INFO_POSX] DEFAULT (300) FOR [POSX],
    CONSTRAINT [DF_TBL_CHARACTER_INFO_POSY] DEFAULT (300) FOR [POSY],
    CONSTRAINT [DF_TBL_CHARACTER_INFO_HAIR] DEFAULT (0) FOR [HAIR],
    CONSTRAINT [DF_TBL_CHARACTER_INFO_SERVER] DEFAULT ('') FOR [SERVER],
    CONSTRAINT [DF_TBL_CHARACTER_INFO_ODATE] DEFAULT (getdate()) FOR [ODATE],
    CONSTRAINT [DF_TBL_CHARACTER_INFO_DELFLAG] DEFAULT (0) FOR [DELFLAG],
    CONSTRAINT [DF_TBL_CHARACTER_INFO_DELDATE] DEFAULT (getdate()) FOR [DELDATE],
    CONSTRAINT [DF_TBL_CHARACTER_INFO_CREATEDATE] DEFAULT (getdate()) FOR [CREATEDATE],
    CONSTRAINT [DF_TBL_CHARACTER_INFO_CUREXP] DEFAULT (0) FOR [CUREXP],
    CONSTRAINT [DF_TBL_CHARACTER_INFO_HP] DEFAULT (0) FOR [HP],
    CONSTRAINT [DF_TBL_CHARACTER_INFO_MP] DEFAULT (0) FOR [MP],
    CONSTRAINT [DF_TBL_CHARACTER_INFO_MAXHP] DEFAULT (0) FOR [MAXHP],
    CONSTRAINT [DF_TBL_CHARACTER_INFO_MAXMP] DEFAULT (0) FOR [MAXMP],
    CONSTRAINT [DF_TBL_CHARACTER_INFO_MINDC] DEFAULT (0) FOR [MINDC],
    CONSTRAINT [DF_TBL_CHARACTER_INFO_MAXDC] DEFAULT (0) FOR [MAXDC],
    CONSTRAINT [DF_TBL_CHARACTER_INFO_MINMC] DEFAULT (0) FOR [MINMC],
    CONSTRAINT [DF_TBL_CHARACTER_INFO_MAXMC] DEFAULT (0) FOR [MAXMC],
    CONSTRAINT [DF_TBL_CHARACTER_INFO_MINSC] DEFAULT (0) FOR [MINSC],
    CONSTRAINT [DF_TBL_CHARACTER_INFO_MAXSC] DEFAULT (0) FOR [MAXSC],
    CONSTRAINT [DF_TBL_CHARACTER_INFO_MINAC] DEFAULT (0) FOR [MINAC],
    CONSTRAINT [DF_TBL_CHARACTER_INFO_MAXAC] DEFAULT (0) FOR [MAXAC],
    CONSTRAINT [DF_TBL_CHARACTER_INFO_MINMAC] DEFAULT (0) FOR [MINMAC],
    CONSTRAINT [DF_TBL_CHARACTER_INFO_MAXMAC] DEFAULT (0) FOR [MAXMAC],
    CONSTRAINT [DF_TBL_CHARACTER_INFO_WEIGHT] DEFAULT (0) FOR [WEIGHT],
    CONSTRAINT [DF_TBL_CHARACTER_INFO_HANDWEIGHT] DEFAULT (0) FOR [HANDWEIGHT],
    CONSTRAINT [DF_TBL_CHARACTER_INFO_BODYWEIGHT] DEFAULT (0) FOR [BODYWEIGHT],
    CONSTRAINT [DF_TBL_CHARACTER_INFO_GOLD] DEFAULT (0) FOR [GOLD],
    CONSTRAINT [DF_TBL_CHARACTER_INFO_MAPID] DEFAULT (0) FOR [MAPID],
    CONSTRAINT [DF_TBL_CHARACTER_INFO_YUANBAO] DEFAULT (0) FOR [YUANBAO],
    CONSTRAINT [DF_TBL_CHARACTER_INFO_FLAG1] DEFAULT (0) FOR [FLAG1],
    CONSTRAINT [DF_TBL_CHARACTER_INFO_FLAG2] DEFAULT (0) FOR [FLAG2],
    CONSTRAINT [DF_TBL_CHARACTER_INFO_FLAG3] DEFAULT (0) FOR [FLAG3],
    CONSTRAINT [DF_TBL_CHARACTER_INFO_FLAG4] DEFAULT (0) FOR [FLAG4],
        CONSTRAINT [DF_TBL_CHARACTER_INFO_GUILDNAME] DEFAULT ('') FOR [GUILDNAME],
        CONSTRAINT [DF_TBL_CHARACTER_INFO_FORGEPOINT] DEFAULT (0) FOR [FORGEPOINT],
        CONSTRAINT [DF_TBL_CHARACTER_INFO_PROP1] DEFAULT (0) FOR [PROP1],
        CONSTRAINT [DF_TBL_CHARACTER_INFO_PROP2] DEFAULT (0) FOR [PROP2],
        CONSTRAINT [DF_TBL_CHARACTER_INFO_PROP3] DEFAULT (0) FOR [PROP3],
        CONSTRAINT [DF_TBL_CHARACTER_INFO_PROP4] DEFAULT (0) FOR [PROP4],
        CONSTRAINT [DF_TBL_CHARACTER_INFO_PROP5] DEFAULT (0) FOR [PROP5],
        CONSTRAINT [DF_TBL_CHARACTER_INFO_PROP6] DEFAULT (0) FOR [PROP6],
        CONSTRAINT [DF_TBL_CHARACTER_INFO_PROP7] DEFAULT (0) FOR [PROP7],
        CONSTRAINT [DF_TBL_CHARACTER_INFO_PROP8] DEFAULT (0) FOR [PROP8],
GO

谢谢

谢谢2位，可以了