summaryrefslogtreecommitdiffstats
path: root/system/database/drivers/mssql
diff options
context:
space:
mode:
authorDerek Allard <derek.allard@ellislab.com>2008-04-07 16:01:01 +0200
committerDerek Allard <derek.allard@ellislab.com>2008-04-07 16:01:01 +0200
commit2385d30422b865052bbc6f333e6a189f46215a61 (patch)
tree396a5623d07b711ab1da0f92a61d1276f80d9fce /system/database/drivers/mssql
parent16629b1cef61db05646839d6789d98ddc5aaf16b (diff)
Added rename_table() into DBForge.
Diffstat (limited to 'system/database/drivers/mssql')
-rw-r--r--system/database/drivers/mssql/mssql_forge.php19
1 files changed, 19 insertions, 0 deletions
diff --git a/system/database/drivers/mssql/mssql_forge.php b/system/database/drivers/mssql/mssql_forge.php
index baf776c74..63063f259 100644
--- a/system/database/drivers/mssql/mssql_forge.php
+++ b/system/database/drivers/mssql/mssql_forge.php
@@ -215,5 +215,24 @@ class CI_DB_mssql_forge extends CI_DB_forge {
}
+ // --------------------------------------------------------------------
+
+ /**
+ * Rename a table
+ *
+ * Generates a platform-specific query so that a table can be renamed
+ *
+ * @access private
+ * @param string the old table name
+ * @param string the new table name
+ * @return string
+ */
+ function _rename_table($table_name, $new_table_name)
+ {
+ // I think this syntax will work, but can find little documentation on renaming tables in MSSQL
+ $sql = 'ALTER TABLE '.$this->db->_protect_identifiers($table_name)." RENAME TO ".$this->db->_protect_identifiers($new_table_name);
+ return $sql;
+ }
+
}
?> \ No newline at end of file