Increased schema flexibility in SAP HANA

Schema flexibility is one of the key capabilities  in SAP HANA that majorly helps to bring in flexibility with the column store table definition. A brief insight with a good example can be seen in this  Getting flexible with SAP HANA.

Let us now understand the new capabilities in schema flexibility with this document.

With HANA SPS11 customers can now avail the increases capabilities of schema flexibility in SAP HANA, let us now understand the same via some examples.

Create a column table to store the employee details considering his Name, ID and Age by giving a room to add the other necessary information of employee based on the needs at run time by using the below syntax :

Create column table employee_Details (emp_id int, emp_name varchar(100), AGE int) with schema flexibility;