on 12-15-2015 7:30 AM
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
Anything wrong with your web search?
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I've found column's information in sys.table_columns and sys.view_columns.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Jassy,
Can you please check in _SYS_BI or _SYC_BIC Tables.
Regards.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
95 | |
11 | |
11 | |
10 | |
9 | |
8 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.