There is no DESC command on HANA database to get “description” about a table structure, therefore if you need to get this information u can use the following SQL command on HANA database…

We can use the TABLE_COLUMNS table to get this information like below ;

SELECT * FROM TABLE_COLUMNS where TABLE_NAME= <TABLE_NAME> ;

Example for table USR02 for schema SAPSR3;

SELECT COLUMN_NAME,DATA_TYPE_NAME FROM TABLE_COLUMNS where TABLE_NAME= ‘USR02′ ORDER BY POSITION