For DBAs used to Oracle sqlplus, not being able to do a “describe my_view” via hdbsql can sometimes be frustrating. This is especially frustrating since it is possible to do it for a table.

In order to overcome this lack, I have written a small procedure which allows to reproduce almost the same result as the “\dc” command for a table.

This is still more constraining than a simple “describe” or “desc”, but it avoids having to manually query the “VIEW_COLUMNS” view or search the SAP documentation to get the view definition.

Continue reading “Describe views in HDBSQL (SAP HANA 2.0 SP03 or higher)” →