--判断数据库是否存在if exists (select * from sys.databases where name = ‘数据库名‘)drop database [数据库名]--判断表是否存在if exists (select * from sysobjects where id = object_id(N‘[表名]‘) and OBJECTPROPERTY(id, N‘IsUserTable‘) = 1)drop table [表名]--判断存储过程是否存在if exists (select * from sysobjects where id = object_id(N‘[存储过程名]‘) and OBJECTPROPERTY(id, N‘IsProcedure‘) = 1)drop procedure [存储过程名]--判断函数是否存在IF OBJECT_ID (N‘函数名‘) IS NOT NULLDROP FUNCTION dnt_split--判断数据库是否开启了全文搜索select databaseproperty(‘数据库名‘,‘isfulltextenabled‘)--判断全文目录是否存在select * from sysfulltextcatalogs where name =‘全文目录名称‘