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";
}