HSQLDB : Get table indices

2k Views Asked by At

I need a way to find out if a present table in HSQLDB has any indices, and if so, fetch their detailed information (column_name, type, isPrimary ...etc)

1

There are 1 best solutions below

0
On BEST ANSWER
select *
from INFORMATION_SCHEMA.SYSTEM_INDEXINFO

More details about the system views can be found in the manual: http://hsqldb.org/doc/2.0/guide/databaseobjects-chapt.html#dbc_information_schema