cakephp / phinx

    /**

     * {@inheritdoc}

     */

    public function hasTable($tableName)

    {

        $options = $this->getOptions();

        $exists = $this->fetchRow(sprintf(

            "SELECT TABLE_NAME

            FROM INFORMATION_SCHEMA.TABLES

            WHERE TABLE_SCHEMA = '%s' AND TABLE_NAME = '%s'",

            $options['name'],

            $tableName

        ));

        return ! empty($exists);

    }

    /**

     * {@inheritdoc}

     *

     * @return array

     */

    public function describeTable($tableName)

    {

        $options = $this->getOptions();

        // mysql specific

        $sql = sprintf(

            "SELECT *

             FROM information_schema.tables

             WHERE table_schema = '%s'

             AND table_name = '%s'",

            $options['name'],

            $tableName

        );

        return $this->fetchRow($sql);

    }

    /**

     * Returns MySQL column types (inherited and MySQL specified).