on 11-05-2018 11:36 AM
Where to see sequences and indexes in hybris system either via hac or Backoffice?
I'm using Hybris 6.7 and HSQLDB . It is saying index or sequence already created but i couldn't check whether it is already available in system or not.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
you can not see it in hac or backoffice directly. You need to use either a native sql query or connect with a ui to the hsqldb.
Query would be:
select * from INFORMATION_SCHEMA.SYSTEM_INDEXINFO
query could be executed in hac or via Databasemanager http://hsqldb.org/doc/util-guide/dbm-chapt.html. More info http://hsqldb.org/doc/2.0/guide/databaseobjects-chapt.html#dbc_information_schema
UI would be razorsql
Please not that it is not recommended to use HSQLDB on productions system
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.