Note that actual parameter of password policy section is maintained by indexserver.ini system file. It is recommended that password policy should be configured using Security editor of SAP HANA Studio however this can also be done by editing indexserver.ini file.

The last folder in SAP HANA Studio system navigation is Security and it has 3 subfolders inside it that define the system security policy and user management activities −SecurityUserRolesSecurity tab is used to manage Password Policy in HANA system −

To execute the table creation, click on the green arrow mark on the top right corner. You will get a confirmation as below that a column table has been created in Schema AA_HANA11 with name DEMO_TABLE −Statement 'create column table "AA_HANA11"."DEMO_TABLE"( "CUST ID" INTEGER null, "CUST NAME" VARCHAR (10) null)' successfully executed Affected Rows:0 in 5 ms 884 µs.

Following table type available in SAP HANA Studio −RowColumnTable Type − this can be changed later as per requirement

You can also create a table in the HANA database using GUI option in the HANA studio. To create a new table, you need to select Schema right-click → New Table and in the right pane, you can define the table.In table creation wizard, you need to enter TABLE NAME and Scheme in which you want to create this table and Table Type- Row or Column Store or Table Type.To add columns to the table, you need to click on “+” sign and a new column is added. You have to define an SQL data type, dimension and Key in ... Read More

To convert a Column store table to row store, you can use the following SQL statement −Alter table Table_Name row;

You can also convert a Column store table to a Row store table or a Row store table to Column store table using ALTER table command.Alter table "AA_HANA11"."DEMO_HANA" column;

Yes, it is possible to differentiate between both the table types.  When you go to schema and view the newly created table, you can see vertical lines in front of table name and it confirms that this is column store table.In below pic, you can see the difference between a Row store table and Column store table.

To create a Column store table, you need to enter “Column” keyword in Create table command.Create column Table Test_ColumnTB1 (    Cust_ID INTEGER,    Cust_NAME VARCHAR(10),    PRIMARY KEY (Cust_ID) );

To check table definition, you need to right click on table name → Open Definition and this will open table structure under HANA database.