判断SQL Server中是否数据库，删除

#region 判断数据库是否存在，删除库
        public void GetConnectionStringConfig(string execonfigPath, string strKey)
        {
            try
            {

                //查找*.exe.config里面的数据库配置
                Configuration config = ConfigurationManager.OpenExeConfiguration(@"E:\MyC#StudioSpace\InstallerIIS\DelegateSQLTable\bin\Debug\DelegateSQLTable.exe");
                string connectionStringsSection = config.ConnectionStrings.ConnectionStrings["ZFSContext"].ConnectionString.Replace("Initial catalog=ZFS;", "");


                //删除表:delete from table（表名称）
                //删除数据表: drop database 数据库
                // SqlConnection conn = new SqlConnection("Data Source=localhost;Initial Catalog=DB;Persist Security Info=True;User ID=数据库登录名;Password=数据库登录密码");
                SqlConnection conn = new SqlConnection(connectionStringsSection);
                string sql1 = "drop database ZFS";
                conn.Open();
                //判断数据库是否存在
                if (CheckExistsTable("ZFS", conn))
                {
                    SqlCommand comm = new SqlCommand(sql1, conn);
                    comm.ExecuteNonQuery();
                }
                conn.Close();
            }
            catch (Exception e)
            {
                Console.WriteLine(e);
            }
        }
        /// <summary>
        /// 判断数据库表是否存在执行一个不需要返回值的SqlCommand命令。
        /// </summary>
        /// <param name="databaseName">ZFS库</param>
        /// <returns></returns>
        private bool CheckExistsTable(string databaseName, SqlConnection con)
        {
            string sqlCheckDBQuery = string.Format("select database_id from sys.databases where name = '{0}'", databaseName);
            SqlCommand cmd = new SqlCommand(sqlCheckDBQuery, con);
            int result = Convert.ToInt32(cmd.ExecuteScalar());
            if (result == 0)
            {
                return false;
            }
            else
            {
                return true;
            }
        }
        #endregion

附数据库命令网站：

http://www.w3school.com.cn/sql/sql_select_into.asp