flexible search query for table description

[former_member770669]

Hi gurus.

I am beginner in SAP Hybris.

I want to know description of particular table (means which fields are present in tables and what are datatypes of those fields and all like we do in sql ) through HAC.

When i enter "describe {table name} " this query in HAC,its giving me an error that "query is not correct"

Please help me with correct query or any other possible solution

[former_member763929]

Thank you for visiting SAP Community to get answers to your questions. Since this is your first question, I recommend that you familiarize yourself with Community Q&A , as the overview provides tips for preparing questions that draw responses from our members.

Should you wish, you can revise your question by selecting Actions, then Edit.

By adding a picture to your Profile you encourage readers to respond.

[former_member770669]

Plz help me with solution

[former_member634058]

Hi Raman,

Flexible queries are only applicable for DQL statements, like Select queries. It is not possible to check description of a table in the way you have mentioned in your question.

If required, you can set up sql db in your local, and use that instead of hsqldb. Or you can setup hsql db viewer like dbeaver and check the table descriptions in the db viewer.

Thanks.