Skip to Content
0
Jun 07, 2020 at 02:57 PM

drop dependent object

613 Views Last edit Jun 07, 2020 at 02:58 PM 2 rev

Hi Experts, to the following error:

I tried to delete the DB2 schema:

db2 "drop schema MYSCHEMA RESTRICT"

And get this error message:

DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL0478N The statement failed because one or more dependencies exist on the
target object. Target object type: "SCHEMA". Name of an object that is
dependent on the target object: "MYSHEMA./1BS/TEST_TABLE". Type of object that
is dependent on the target object: "TABLE". SQLSTATE=42893

How can I drop my schema ?

Many Thanks

Best regards