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]
Aangemelde leden kunnen berichten plaatsen, updates volgen en meer. Nieuw hier? Registreer een gratis account.
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.
