Altering a database view in SAP HANA

You can alter the view, then we can use the Alter View command to alter the view.


Alter view View_EmpInfo  as Select Emp_Details.Id, Emp_Details.EmplName,
EmpProj.Projname from Emp_Details inner join EmpProjInfo
on Emp_Details.Id=EmpProjInfo.Id;

We have applied ALTER command to update an existing view with name- View_EmpInfo which is applying Inner Join on two tables on Id column to create a database view.

Updated on: 21-Feb-2020


Kickstart Your Career

Get certified by completing the course

Get Started