Get Description for a HANA Table Instead of usage DESC

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> ;

Get Description for a HANA Table (Instead of usage DESC)

Example for table USR02 for schema SAPSR3;

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

Get Description for a HANA Table (Instead of usage DESC)

 

 

 

 

 

 

Leave a Reply


six + = 9

Blogroll