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

CREATE TABLE [dbo].[Noticias] (
[Titulo] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
[Id] [bigint] IDENTITY (1, 1) NOT NULL ,
[Por] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[Data] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
[Tipo] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[Noticia] [text] COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]