Return
-
Title
Toad tries to drop tables with restrict on drop option and that cannot be done direclty -
Description
Toad tries to drop tables with restrict on drop option and that cannot be done direclty as you get an "SQL0672N Operation DROP not allowed on table" error.
Toad should first make an "alter table drop restrict on drop".To reproduce the problem please follow the steps below:
1] Create the table below:ÃCREATE TABLE "TARESTRICT" (
"COL1" CHARACTER(1) NOT NULL
)
WITH RESTRICT ON DROP;
Ã2] Drop it with Toad
Sign In Required
You need to be signed in and under a current maintenance contract to view premium knowledge articles.