- Trending Categories
Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
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
Understanding a database view in SAP HANA database
Consider the following example −
Example
| Id | Empl. Name | Empl.user | Empl.password | Joining Date |
| 1 | Employee 1 | Emp1 | Emp1Pwd | 9/11/2016 |
| 2 | Employee 2 | Emp2 | Emp2Pwd | 16/08/2015 |
| 3 | Employee 3 | Emp3 | Emp3Pwd | 15/09/2016 |
| 4 | Employee 4 | Emp4 | Emp4Pwd | 3/07/2014 |
| 5 | Employee 5 | Emp5 | Emp5Pwd | 10/09/2012 |
| 6 | Employee 6 | Emp6 | Emp6Pwd | 1/10/2013 |
Consider a scenario when a developer needs to analyze some data of Employee Table with the above fields. Using database view, an administrator can create a virtual table which only contains information about Employee Id, Employee name, and date of joining and give permission to developer to use that view.
- Related Articles
- Finding a database view in SAP HANA database
- Dropping a SAP HANA database view
- Altering a database view in SAP HANA
- Using database view in SAP HANA
- Create View SQL in SAP HANA database
- Example of creating a database view in SAP HANA
- SAP HANA database functions in HANA Cockpit
- Create database view in SAP ABAP
- Unloading tables in SAP HANA database
- Database objects in SAP HANA Studio
- Default table type in SAP HANA database
- Creating column table in SAP HANA database
- Create User SQL in SAP HANA database
- Password blacklist table in SAP HANA database
- Checking schema creation in SAP HANA database
Advertisements