Skip to Content
Former Member
Apr 07, 2015 at 06:04 PM

How do we add Foreign key to a HDBTABLE



We are using SP8 hdbtable concept and created tables in HANA. Now we want enforce referential integrity on few tables and hence looking for syntaxc on how we apply foreign key constraints on the table definition on Development perspective.

I creating a run time object, stored procedure, But I am getting an error ALTER syntax is not supported as SQL Script.

Please let me know the possible approaches. We also need to transport the piece of the code to Q and P systems.