select rastercolumn_id from sde.sde_raster_columns where table_name = '[table_name]' select layer_id from sde.sde_layers where table_name = '[table_name]' --Recall the two numbers from these queries. Then run the following queries: delete from sde.GDB_ITEMS where Name = '<datbase>.<owner>.[table_name]' delete from sde.sde_table_registry where table_name = '[table_name]' delete from sde.sde_layers where table_name = '[table_name]' delete from sde.sde_raster_columns where table_name = '[table_name]' delete from sde.sde_geometry_columns where f_table_name = '[table_name]' DROP TABLE <owner>.[table_name] DROP TABLE <owner>.sde_aux_<# from above rastercolumn_id query> DROP TABLE <owner>.sde_bnd_<#> DROP TABLE <owner>.sde_blk_<#> DROP TABLE <owner>.sde_ras_<#> DROP TABLE <owner>.f[number from above sde_layers query] DROP TABLE <owner>.s[number from above sde_layers query]
Signed in members can post, follow updates, and more. New here? Register a free account.
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.
