Net Core框架下的NewsPublish项目：数据库重建与设计

if exists (select 1
   from sys.sysreferences r join sys.sysobjects o on (o.id = r.constid and o.type = 'F')
   where r.fkeyid = object_id('News') and o.name = 'FK_NewsClassify_News')
alter table News
   drop constraint FK_NewsClassify_News
go

if exists (select 1
   from sys.sysreferences r join sys.sysobjects o on (o.id = r.constid and o.type = 'F')
   where r.fkeyid = object_id('NewsComment') and o.name = 'FK_News_NewsComment')
alter table NewsComment
   drop constraint FK_News_NewsComment
go

if exists (select 1
            from  sysobjects
           where  id = object_id('Banner')
            and   type = 'U')
   drop table Banner
go

if exists (select 1
            from  sysobjects
           where  id = object_id('News')
            and   type = 'U')
   drop table News
go

if exists (select 1
            from  sysobjects

           where  id = object_id('NewsClassify')
            and   type = 'U')
   drop table NewsClassify
go

if exists (select 1
            from  sysobjects
           where  id = object_id('NewsComment')
            and   type = 'U')
   drop table NewsComment
go

/*==============================================================*/
/* Table: Banner                                                */
/*==============================================================*/
create table Banner (
   Id                   int                  identity,
   Image                varchar(200)         not null,
   Url                  varchar(100)         null,
   AddTime              datetime             null,
   Remark               varchar(200)         null,
   constraint PK_BANNER primary key (Id)
)
go

declare @CurrentUser sysname
select @CurrentUser = user_name()
execute sp_addextendedproperty 'MS_Description', 
   'Banner表',
   'user', @CurrentUser, 'table', 'Banner'