Updating tables with foreign key constraints

When trying to delete a Customer which already has some orders created for it, HANA will cascade the deletion statement to the referencing orders, i.e., it will delete the customer and all orders of that customer.In this case, Order #2, which referred Customer #2, was deleted from the “ORDER” table.

Running the same test as above, we finally get the expected entries in the Order table, hence proving the failed loading was indeed due to the FK.

Next, I altered the referential action of the FK to “CASCADE”, in order to evaluate its behvaior.

Actually, I dropped the original FK and created an additional one.

If you haven’t defined a proper name for the FK (e.g.

during CREATE TABLE statement), HANA will define an internal name, which can be found in this table, under the “CONSTRAINT_NAME” column.

Leave a Reply

  1. 100 free video chat xxx older women 24-Dec-2019 10:38

    She sends the triplets ('84, '85, and '86) packing before the elimination ceremony saying that she thought they were awesome, but that she is serious about finding love and will not share men or be shared by men.

  2. things to say on dating sites about yourself 11-Feb-2020 02:59

    Hotel staff exceeded our expectations entirely and we would absolutely come back again. August Jack Motor Inn has a 24-hour front desk, as well as coin laundry facilities. This holiday home offers free private parking, a shared kitchen and free Wi Fi.

  3. Drunk girla sex web cam chat free vedios 24-Oct-2019 22:53

    "Just make sure it's a normal, mundane week so you'll get a real feel for what the morning rush is like, what the dishwashing situation is like."The key, no matter how long you've been living together: When confronted with one of those fingernails-on-the-chalkboard-of-life moments, don't let it slide. Wynne Whitman, coauthor of , prefers a gentler, more constructive approach.

  4. worst online dating emails 11-Sep-2019 22:20

    Women have a different set of social and personal safety challenges than guys.