doctrine / dbal

     * Two approaches to listing the table indexes. The information_schema is

     * preferred, because it doesn't cause problems with SQL keywords such as "order" or "table".

     */

    public function getListTableIndexesSQL($table, $currentDatabase = null)

    {

        if ($currentDatabase) {

            $currentDatabase = $this->quoteStringLiteral($currentDatabase);

            $table = $this->quoteStringLiteral($table);

            return "SELECT TABLE_NAME AS `Table`, NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, ".

                   "SEQ_IN_INDEX AS Seq_in_index, COLUMN_NAME AS Column_Name, COLLATION AS Collation, ".

                   "CARDINALITY AS Cardinality, SUB_PART AS Sub_Part, PACKED AS Packed, " .

                   "NULLABLE AS `Null`, INDEX_TYPE AS Index_Type, COMMENT AS Comment " .

                   "FROM information_schema.STATISTICS WHERE TABLE_NAME = " . $table . " AND TABLE_SCHEMA = " . $currentDatabase;

        }

        return 'SHOW INDEX FROM ' . $table;

    }

    /**

     * {@inheritDoc}

    /**

     * {@inheritDoc}

     */

    public function getListTableColumnsSQL($table, $database = null)

    {

        $table = $this->quoteStringLiteral($table);

        if ($database) {

            $database = $this->quoteStringLiteral($database);

        } else {

            $database = 'DATABASE()';

        }

        return "SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, ".

               "COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, " .

               "CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation ".

               "FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = " . $database . " AND TABLE_NAME = " . $table;

    }

    /**

     * {@inheritDoc}