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