Issue #23507:add cascade to column drop

diff --git a/foundation-database/public/tables/itemsite.sql b/foundation-database/public/tables/itemsite.sql
index 6987426..5c5f7c4 100644 (file)
--- a/foundation-database/public/tables/itemsite.sql
+++ b/foundation-database/public/tables/itemsite.sql
@@ -3,6 +3,6 @@ do $$
 begin
 if fetchMetricText('ServerVersion') < '4.7.0' then
   update itemsite set itemsite_qtyonhand=(itemsite_qtyonhand + itemsite_nnqoh);
-  alter table itemsite drop column itemsite_nnqoh;
+  alter table itemsite drop column itemsite_nnqoh cascade;
 end if;
 end$$;
\ No newline at end of file