- Trending Categories
Data Structure
Networking
RDBMS
Operating System
Java
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Physics
Chemistry
Biology
Mathematics
English
Economics
Psychology
Social Studies
Fashion Studies
Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
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.
- Related Articles
- 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
- Consuming Attribute/Analytic view in a Calculation view in SAP HANA
- SAP HANA database functions in HANA Cockpit
- Using Attribute view in SAP HANA
- Using Analytic View in SAP HANA
- Create database view in SAP ABAP
- Creating a mandatory variable in SAP HANA View
- Data Preview option in HANA Modeling view in SAP HANA

Advertisements