- 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
Example of creating a database view in SAP HANA
Let us see the below table ARTICLE_LOOKUP, we will create a database view with first 4 columns and will hide Family_NAME and FAMILY_CODE.
SQL statement- To create a view on the above table, write down the below SQL statement
create view view_Articlelookup as select ARTICLE_ID,ARTICLE_LABEL,CATEGORY,SALE_PRICE from "AA_HANA11"."ARTICLE_LOOKUP";
This will create a database view in the mentioned schema and you can check it in Views folder (schema name here-AA_HANA11). You can see a view with the name- view_Articlelookup and only 4 data columns are there.
Published on 21-Feb-2018 15:06:02
- 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
- Altering a database view in SAP HANA
- Creating a mandatory variable in SAP HANA View
- Using database view in SAP HANA
- Creating an Attribute view in SAP HANA
- Create View SQL in SAP HANA database
- Creating column table in SAP HANA database
- Creating a copy of an existing Attribute view in SAP HANA
- Query in Analytic view creating unexpected results in SAP HANA
- Refreshing a schema after creating a table in SAP HANA database
- Creating Attribute and Analytic view as persistent model in SAP HANA
- Creating Attribute and Analytic view as persistent model in SAP HANA
- Exporting a SAP HANA Modeling view
Advertisements