Skip to main content
Skip table of contents

"Cannot Drop Table" Error (Log entry)

DS ERROR : 10136.10005 – Cannot DROP TABLE <table-name> because it is being referenced by object <view-name>.
Problem may be due to a SQL view created using schema binding.

For some operations ETL+ drops and re-creates tables and views in the data warehouse. As of ETL+ version 2024.10.1905.35, ETL+ cannot drop tables created using the WITH SCHEMABINDING clause.

What is Schema Binding

Schema binding is established when a view is created using the WITH SCHEMABINDING clause.

CREATE VIEW <view-name>


Recreate the SQL view in the target data warehouse with a view that does not use the WITH SCHEMABINDING clause.

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.