判断数据库是否存在,存在则删除,然后结束。然后新建库
IF EXISTS (select * From master.dbo.sysdatabases where name='DBPersonnel' )
DROP DATABASE DBPersonnel
GO
CREATE DATABASE DBPersonnel
GO
判断表是否存在,存在则删除,然后结束。然后新建表
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[TB廃棄申請]') AND type in (N'U'))BEGIN
CREATE TABLE [dbo].[TB廃棄申請]