From 6f52325abecad238b4c0a3097b0d849bf685adce Mon Sep 17 00:00:00 2001
From: tino <tino@quadforce>
Date: Fri, 18 Oct 2013 11:21:47 +0200
Subject: Fix on sqlsrv_forge drop_table

---
 system/database/drivers/sqlsrv/sqlsrv_forge.php | 9 ++++++++-
 1 file changed, 8 insertions(+), 1 deletion(-)

(limited to 'system/database')

diff --git a/system/database/drivers/sqlsrv/sqlsrv_forge.php b/system/database/drivers/sqlsrv/sqlsrv_forge.php
index cc88ec5ca..d800c5074 100644
--- a/system/database/drivers/sqlsrv/sqlsrv_forge.php
+++ b/system/database/drivers/sqlsrv/sqlsrv_forge.php
@@ -60,7 +60,14 @@ class CI_DB_sqlsrv_forge extends CI_DB_forge {
 	 */
 	function _drop_table($table)
 	{
-		return "DROP TABLE ".$this->db->_escape_identifiers($table);
+		$sql = '';
+                $sql = "IF (EXISTS (SELECT * 
+                                FROM INFORMATION_SCHEMA.TABLES 
+                                WHERE TABLE_SCHEMA = 'dbo' 
+                                AND  TABLE_NAME = '";
+                $sql .= $this->db->_escape_identifiers($table)."')) DROP TABLE [dbo].[";
+                $sql .= $this->db->_escape_identifiers($table).']';
+		return $sql;
 	}
 
 	// --------------------------------------------------------------------
-- 
cgit v1.2.3-24-g4f1b