Doctrine\DBAL\Platforms\DB2Platform::getListTableIndexesSQL PHP Метод

getListTableIndexesSQL() публичный Метод

{@inheritDoc}
public getListTableIndexesSQL ( $table, $currentDatabase = null )
    public function getListTableIndexesSQL($table, $currentDatabase = null)
    {
        $table = $this->quoteStringLiteral($table);
        return "SELECT   idx.INDNAME AS key_name,\n                         idxcol.COLNAME AS column_name,\n                         CASE\n                             WHEN idx.UNIQUERULE = 'P' THEN 1\n                             ELSE 0\n                         END AS primary,\n                         CASE\n                             WHEN idx.UNIQUERULE = 'D' THEN 1\n                             ELSE 0\n                         END AS non_unique\n                FROM     SYSCAT.INDEXES AS idx\n                JOIN     SYSCAT.INDEXCOLUSE AS idxcol\n                ON       idx.INDSCHEMA = idxcol.INDSCHEMA AND idx.INDNAME = idxcol.INDNAME\n                WHERE    idx.TABNAME = UPPER(" . $table . ")\n                ORDER BY idxcol.COLSEQ ASC";
    }