Default table type in SAP HANA database


By default it creates a Row store table. The horizontal lines in front of table name represents row based storage table in database. HANA database also supports column store tables but you need to add a keyword “Column” in create table query.

Below snapshot confirms that by default a row based table is created.

Updated on: 30-Jul-2019

379 Views

Kickstart Your Career

Get certified by completing the course

Get Started
Advertisements