解决ArcSDE图层名被占用的问题

时间:2021-08-08 23:06:53

点击文章查看

当你发现上面那篇文章时你已经接近成功了,但还差最后一步!

<!-

-delete   from sde.GDB_OBJECTCLASSES where NAME = upper('test') and owner =upper('ttt') ;

delete   from sde.gdb_usermetadata where NAME = upper('test') and owner =upper('ttt') ;

-->

估计安装的sde版本不同,所以上面两条不能用

delete  from sde.GEOMETRY_COLUMNS where F_TABLE_NAME =upper('test') and F_table_schema =upper('ttt') ;
delete   from sde.GEOMETRY_COLUMNS where G_TABLE_NAME = upper('test') and G_table_schema =upper('ttt') ;
delete   from sde.LAYERS where TABLE_NAME = upper('test') and owner =upper('ttt') ;
delete   from sde.ST_GEOMETRY_INDEX where TABLE_NAME = upper('test')and owner =upper('ttt') ;
delete   from sde.TABLE_REGISTRY where TABLE_NAME = upper('test')and owner =upper('ttt') ;
delete   from sde.column_registry t where table_name = upper('test')and  t.owner =upper('ttt') ;
delete  from sde.ALL_ST_GEOMETRY_COLUMNS_V where TABLE_NAME = upper('test') and owner =upper('ttt') ;
delete   from sde.ST_GEOMETRY_COLUMNS where TABLE_NAME = upper('test') and owner =upper('ttt') ;
<-下面这个是我自己找的->
delete   from sde.ITEMS where NAME = upper('sde.test') and owner =upper('ttt') ;