davideairaghi / php

repository of php code
Apache License 2.0
12 stars 9 forks source link

The mssql dialect does not work with owners other than dbo. #5

Closed hamster1979 closed 6 years ago

hamster1979 commented 6 years ago

tip: change in dialect php file describeColumns to

public function describeColumns($table, $schema = null)
{
      $sql = "exec sp_columns [$table] , [$schema]";
      return $sql;
}

then in Model php $this->setSchema('Owner'); will work to change owner of table.

davideairaghi commented 6 years ago

thank you for your suggestion, i just commited the change in describeColumns.