arcmap 在oracle删除表重新创建提示表名存在解决放啊

sde表创建是有注册或者是关联关系存在的 按照以下步骤删除表的数据

select t.* from sde.TABLE_REGISTRY t where table_name like 'IRR%';
DELETE from  sde.TABLE_REGISTRY where table_name='IRRIGATION_TYPE';

select t.* from sde.LAYERS t where table_name like 'IRR%';
DELETE from  sde.LAYERS where table_name='IRRIGATION_TYPE';

select t.* from sde.GEOMETRY_COLUMNS t WHERE t.F_TABLE_NAME like 'IRR%';
DELETE from  sde.GEOMETRY_COLUMNS where F_TABLE_NAME='IRRIGATION_TYPE';

select t.* from sde.COLUMN_REGISTRY t where t.TABLE_NAME like 'IRR%';
DELETE from  sde.COLUMN_REGISTRY where TABLE_NAME='IRRIGATION_TYPE';