summaryrefslogtreecommitdiff
path: root/system/libraries/drivers/Database
diff options
context:
space:
mode:
Diffstat (limited to 'system/libraries/drivers/Database')
-rw-r--r--system/libraries/drivers/Database/Mssql.php2
1 files changed, 1 insertions, 1 deletions
diff --git a/system/libraries/drivers/Database/Mssql.php b/system/libraries/drivers/Database/Mssql.php
index 6947679a..8b5ed50b 100644
--- a/system/libraries/drivers/Database/Mssql.php
+++ b/system/libraries/drivers/Database/Mssql.php
@@ -298,7 +298,7 @@ class Database_Mssql_Driver extends Database_Driver
public function field_data($table)
{
- $query = $this->query('SHOW COLUMNS FROM '.$this->escape_table($table), $this->link);
+ $query = $this->query("SELECT COLUMN_NAME AS Field, DATA_TYPE as Type FROM INFORMATION_SCHEMA.Columns WHERE TABLE_NAME = '".$this->escape_table($table)."'", $this->link);
return $query->result_array(TRUE);
}