- Trending Categories
Data Structure
Networking
RDBMS
Operating System
Java
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
- 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.
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
- SAP HANA database functions in HANA Cockpit
- Consuming Attribute/Analytic view in a Calculation view in SAP HANA
- Create database view in SAP ABAP
- Creating a mandatory variable in SAP HANA View
- SAP HANA view maintaining license details
Advertisements