Skip to main content
Question

Can you drop a table with DBD-generated projections without using CASCADE?

  • Apr 6, 2020 2:42 PM UTC
  • 0 replies
  • 8 views

MichaelJK

If DBD/Enterprise runs against a schema, currently you can drop a table with DBD-generated projections in that schema only as follows:
(1) Create a superprojection for the table
(2) Drop the DBD-generated projection
(3) Drop the table.
Is there a way to directly drop the table without using CASCADE?