How to add foreign keys in SQL 92 Scripting - HANA SQL

Scenario: Manipulate different tables and estabilsh foreign key relatioinships between them

To alter the relationship between the tables go for attribute or analytical view. In this scenario you can join the table through join type "referential"

You can then get the desired behavior by creating the attribute views, analytical view or by using CE funtions like CE_JOIN,CE_CALC etc. , or by writing simple SQL using 'INNER JOIN', 'OUTER JOIN' etc.






Tags: CE funtions  CE_JOIN,CE_CALC, HANA analytic view , referential keys, 
Share this article :

Post a Comment

 
Copyright © 2011. SAP HANA TUTORIALS FREE - S/4 HANA - All Rights Reserved