RESPOSTA! RODE ESSA QUERY NA DATA BASE MUONLINE NO QUERY ANALYZER!
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Character]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Character]
GO
CREATE TABLE [dbo].[Character] (
[AccountID] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[Name] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[cLevel] [smallint] NULL ,
[LevelUpPoint] [int] NULL ,
[Class] [tinyint] NULL ,
[Experience] [int] NULL ,
[strength] [smallint] NULL ,
[Dexterity] [smallint] NULL ,
[Vitality] [smallint] NULL ,
[Energy] [smallint] NULL ,
[inventory] [varbinary] (760) NULL ,
[MagicList] [varbinary] (60) NULL ,
[Money] [int] NULL ,
[Life] [real] NULL ,
[MaxLife] [real] NULL ,
[Mana] [real] NULL ,
[MaxMana] [real] NULL ,
[MapNumber] [smallint] NULL ,
[MapPosX] [smallint] NULL ,
[MapPosY] [smallint] NULL ,
[MapDir] [tinyint] NULL ,
[PkCount] [int] NULL ,
[PkLevel] [int] NULL ,
[PkTime] [int] NULL ,
[MDate] [smalldatetime] NULL ,
[LDate] [smalldatetime] NULL ,
[CtlCode] [tinyint] NULL ,
[DbVersion] [tinyint] NULL ,
[Quest] [varbinary] (50) NULL ,
[resets] [int] NOT NULL ,
[MasterReset] [int] NULL ,
[count(*)] [int] NULL ,
[dias] [int] NULL ,
[blocpor] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[motivobloc] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[diasbloc] [int] NOT NULL ,
[permipor] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[desblocpor] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[motivodesbloc] [varchar] (250) COLLATE Chinese_PRC_CI_AS NULL ,
[resetsWeek] [int] NOT NULL ,
[resetsMonth] [int] NOT NULL ,
[PkCountWeb] [int] NOT NULL ,
[MResets] [int] NOT NULL ,
[image] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[CTM_Image] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[resetsDay] [int] NOT NULL ,
[HeroCountWeb] [int] NOT NULL ,
[Resetao] [int] NULL ,
[PkCountWebHero] [int] NULL
) ON [PRIMARY]
GO