Hi Thomas, Am Mittwoch, 12. Februar 2014 19:46:53 UTC+1 schrieb Thomas Mueller: > > Hi, > > The column_list is more a comment currently, maybe it should be removed. I > wonder if the following could be used? > > select c.table_schema, c.table_name, > c.unique_index_name, c.column_list, > i.column_name > from information_schema.constraints c, > information_schema.indexes i > where c.table_schema = i.table_schema > and c.table_name = i.table_name > and c.unique_index_name = i.index_name; >
This works perfectly. I don't know why I hadn't chosen to query the INDEXES table in the first place. Thanks, Lukas -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/groups/opt_out.
