Doctrine\DBAL\Platforms\SQLServerPlatform::getListTableIndexesSQL PHP Method

    public function getListTableIndexesSQL($table, $currentDatabase = null)
    {
        return "SELECT idx.name AS key_name,\n                       col.name AS column_name,\n                       ~idx.is_unique AS non_unique,\n                       idx.is_primary_key AS [primary],\n                       CASE idx.type\n                           WHEN '1' THEN 'clustered'\n                           WHEN '2' THEN 'nonclustered'\n                           ELSE NULL\n                       END AS flags\n                FROM sys.tables AS tbl\n                JOIN sys.schemas AS scm ON tbl.schema_id = scm.schema_id\n                JOIN sys.indexes AS idx ON tbl.object_id = idx.object_id\n                JOIN sys.index_columns AS idxcol ON idx.object_id = idxcol.object_id AND idx.index_id = idxcol.index_id\n                JOIN sys.columns AS col ON idxcol.object_id = col.object_id AND idxcol.column_id = col.column_id\n                WHERE " . $this->getTableWhereClause($table, 'scm.name', 'tbl.name') . "\n                ORDER BY idx.index_id ASC, idxcol.key_ordinal ASC";
    }