Ingres:
SELECT iii.*, iic.* FROM iiindexes iii JOIN iiindex_columns iic ON (iii.index_name = iic.index_name)
ORDER BY iii.index_name
Informix:
SELECT st.tabname, sc.colname, sc.colno, si.idxtype, si.*, st.*, sc.*
FROM sysindexes si JOIN systables st ON (si.tabid = st.tabid) JOIN syscolumns sc ON (sc.tabid = st.tabid)
Oracle:
SELECT * FROM user_ind_columns
PostgreSQL:
SELECT i.relname, a.attname, t.*, i.*, ix.*, a.* FROM pg_class t, pg_class i, pg_index ix, pg_attribute a
WHERE t.oid = ix.indrelid AND i.oid = ix.indexrelid AND a.attrelid = t.oid AND a.attnum = ANY(ix.indkey)
Usunięcie wszystkich indeksów z danej relacji na PostgreSQL:
CREATE OR REPLACE FUNCTION drop_all_indexes_on_table (table_name VARCHAR) RETURNS void
AS $$
DECLARE
c_indexes FOR SELECT
DISTINCT i.relname AS index_name
FROM
pg_class t, pg_class i, pg_index ix, pg_attribute a
WHERE
t.oid = ix.indrelid
AND i.oid = ix.indexrelid
AND a.attrelid = t.oid
AND a.attnum = ANY(ix.indkey)
AND t.relkind = 'r'
AND ix.indisprimary != 't'
AND t.relname = 'table_name'
BEGIN
FOR index_entry IN c_indexes LOOP
DROP INDEX index_entry;
END LOOP;
END
$$ LANGUAGE PLPGSQL;
