Altering a database view in SAP HANA

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.

SAP Expert

Published on 21-Feb-2018 17:00:03

• Related Questions & Answers
• Understanding a database view in SAP HANA database
• Finding a database view in SAP HANA database
• Dropping a SAP HANA database view
• Using database view in SAP HANA
• Create View SQL in SAP HANA database
• Example of creating a database view in SAP HANA
• Exporting a SAP HANA Modeling view
• Searching a SAP HANA system in HANA Studio System view
• Using Analytic View in SAP HANA
• Using Attribute view in SAP HANA
• Consuming Attribute/Analytic view in a Calculation view in SAP HANA
• SAP HANA database functions in HANA Cockpit
• Create database view in SAP ABAP
• Creating a mandatory variable in SAP HANA View
• SAP HANA view maintaining license details