cancel
Showing results for 
Search instead for 
Did you mean: 

Create Data Dictionary in Hana

Former Member
0 Kudos

Hi All,

Is there any convenient way to create a data dictionary in SAP HANA database? I guess there should be a system's table which contents column information about each table or view such as column label, data type,dimension and etc.

Any early help is highly appreciated.

Regards,

Jassy

Accepted Solutions (1)

Accepted Solutions (1)

lbreddemann
Active Contributor

Anything wrong with your web search?

https://help.sap.com/saphelp_hanaplatform/helpdata/en/20/cbb10c75191014b47ba845bfe499fe/content.htm?...

Lists all the available HANA system views including those covering the information you're after.

BTW: none of them are in the special _SYS_BI/_SYS_BIC schemas.

Former Member
0 Kudos

thx,very useful!

Answers (2)

Answers (2)

Former Member
0 Kudos

I've found column's information in sys.table_columns and sys.view_columns.

former_member182343
Active Contributor
0 Kudos

Hi Jassy,

Can you please check in _SYS_BI or _SYC_BIC Tables.

Regards.