select owner,constraint_name, constraint_type, table_name, delete_rule from DBA_constraints WHERE table_name='ZWKMZD'

列delete_rule的返回结果若是为CASCADE ，就表示是级联删除