cakephp / phinx

        $this->execute($sql);

    }

    public function getColumnComment($tableName, $columnName)

    {

        $sql = sprintf("SELECT cast(extended_properties.[value] as nvarchar(4000)) comment

  FROM sys.schemas

 INNER JOIN sys.tables

    ON schemas.schema_id = tables.schema_id

 INNER JOIN sys.columns

    ON tables.object_id = columns.object_id

 INNER JOIN sys.extended_properties

    ON tables.object_id = extended_properties.major_id

   AND columns.column_id = extended_properties.minor_id

   AND extended_properties.name = 'MS_Description'

   WHERE schemas.[name] = '%s' AND tables.[name] = '%s' AND columns.[name] = '%s'", $this->schema, $tableName, $columnName);

        $row = $this->fetchRow($sql);

        if ($row) {

            return $row['comment'];

        }

        return false;

    }

    /**

     * {@inheritdoc}

     *

     * @return string

     */

    public function getColumnComment($tableName, $columnName)

    {

        $sql = sprintf(

            "select COMMENTS from ALL_COL_COMMENTS WHERE COLUMN_NAME = '%s' and TABLE_NAME = '%s'",

            $columnName,

            $tableName

        );

        $row = $this->fetchRow($sql);

        if ($row['COMMENTS'] != 'NULL') {

            return $row['COMMENTS'];

        }

        return false;

    }