June 07, 2012

How to check SAP HANA table type

Type the following SQL in the SAP HANA Studio:
select tables.table_name, tables.table_type from sys.tables where tables.table_name = UCASE ('dummy')
to get a list of tables with their types (row, column)

No comments:

Post a Comment