Skip to Content
0
Jan 22, 2021 at 01:54 PM

Best Practice: Temporarily turn off constraint enforcement

58 Views

Hello experts,

I've been experimenting with referential constraints for quite a while now. Most database engines, like sqlite or postgresql, have a mechanism to temporarily switch off the constraint enforcement for the whole database or certain db-schemas. This can come in handy e.g. for mass data migrations.

How can I achieve that on my SAP HANA db? If there is no such feature available, what would be a suitable workaround?

Best Regards,

Patrice