求助db2 drop table不能解决

雪刃狼

在执行db2 drop table XXXX时，出现以下问题，无法删除表，请问大家如何解决该问题，谢谢
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  DROP or REVOKE on object type "TABLE" cannot be processed because
there is an object "LOAN.SQL100928145954400", of type "FUNCTION", which
depends on it.  SQLSTATE=42893

wolfop

先删除那个function LOAN.SQL100928145954400

雪刃狼

解决了，主要是有视图和存储过程关联起来了。谢谢楼上的回答，虽然不对。

_北南_

a function -> {something else | ... ->} -> this table

study123

阁下是怎么解决的吗？
能否贴出来呢？
谢谢！