DB_51aspx/AMS脚本文件.sql

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

/*==============================================================*/
/* DBMS name:      Microsoft SQL Server 2005                    */
/* Created on:     2012-10-30 18:12:16                          */
/*==============================================================*/
use master 
go 
if exists(select * from sys.databases where name='AMS')
drop database AMS
go
create database AMS
go
use AMS
go

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

if exists (select 1
            from  sysindexes
           where  id    = object_id('CommunicationService')
            and   name  = 'Relationship_6_FK'
            and   indid > 0
            and   indid < 255)
   drop index CommunicationService.Relationship_6_FK
go

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

if exists (select 1
            from  sysindexes
           where  id    = object_id('CompanyEmail')
            and   name  = 'Relationship_10_FK'
            and   indid > 0
            and   indid < 255)
   drop index CompanyEmail.Relationship_10_FK
go

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

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