Symptom
When delete object without specify the CASCADE option it works for most of the time, but sometimes below error pops up:
"Can't drop without CASCADE specification: cannot drop table referenced by foreign key: xxx"
Read more...
Environment
- SAP HANA Platform edition 1.0 & 2.0 and higher
- SAP HANA Cloud 1.0 and higher
Product
SAP HANA 1.0, platform edition ; SAP HANA Cloud 1.0 ; SAP HANA, platform edition 2.0
Keywords
Can't drop without, CASCADE, RESTRICT, drop_option, cannot drop table, foreign key, dependencies, dependency , KBA , HAN-DB , SAP HANA Database , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.