Create View SQL in SAP HANA database

>Create View View_name as
Select Col1,Col2 From Table_name;

In the above SQL statement, you are creating a view that contains Col1 and Col2 from the table.

Table Name − Emp_Info

Example

To create a view, which contains only 3 columns you have to write-

>Create View View_EmpInfo As
Select Id, EmplName,Joining_Date  From Emp_Info;

This view can be used by users to get Id, EmplName, and Joining_date.

SAP ABAP Expert

Updated on: 22-Jun-2020

3K+ Views

Kickstart Your Career

Get certified by completing the course

Get Started