Altering a database view in SAP HANA

SAP HANASAPSAP Basis

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

Example

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.

raja
Published on 21-Feb-2018 21:30:03
Advertisements