How do we find foreign keys in SAP HANA ?

[Former Member]

Hi guys,

I have a simple question, How do we find foreign keys in SAP HANA ?

Cheers,

Aryan

[rama_shankar3]

Write a SQL statement on top of the above table. I had build a SQL will look for it and post it soon that will display all table and fields with referencial columns shortly.

[henrique_pinto]

Just query the "_SYS_STATISTICS"."REFERENTIAL_CONSTRAINTS" table.

http://help.sap.com/hana/html/_r_e_f_e_r_e_n_t_i_a_l__c_o_n_s_t_r_a_i_n_t_s.html